473,503 Members | 9,912 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How do I Allow Dates Without Separators, but Show Them With Separators

2 New Member
Having the ability to enter date in 2010 access form without seperators but date is displayed with seperators.
Example date is entered as 01222010 (which January 22nd,2010)but displayed as 01/22/2010.
Would like help as to how to achieve the above
Feb 23 '12 #1
3 2191
TheSmileyCoder
2,322 Recognized Expert Moderator Top Contributor
Open the textbox in question and find the format property. Write "mm/dd/yyyy".
Feb 23 '12 #2
NeoPa
32,557 Recognized Expert Moderator MVP
You should prepare your question better before posting. This doesn't make what you want very clear at all. Please remember in future.

I'm understanding you would like the operator to enter an 8-digit string and have that interpreted as a date. If so, then formatting won't be enough for you. You will need to write some code in a BeforeUpdate() event procedure which validates and converts the string (which is not a generally recognised or supported date format) into a format that is that as well as unambiguous. The format of the control (or even the field it's bound to if bound) should be as suggested by Smiley in post #2 (mm/dd/yyyy).
Feb 23 '12 #3
HelpNeed
2 New Member
@TheSmileyCoder
The form is bound to the table. I went into the design view of the table and the chose in data type Date/Time. In Format (under General) I inital had short date but changed that to "mm/dd/yyy". However entering the date in form as a string does not result date being displayed with separators.
Feb 27 '12 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
3681
by: Ray | last post by:
Date problem. Using non American date formats with Microsoft Access and Visual Basic. I set my regional settings to English(Ireland) or English(United Kingdom) and my date appears in Access as...
2
11672
by: Josh Strickland | last post by:
I am attempting to create an Access database which uses forms to enter data. The issue I am having is returning the query results from the Stored Procedure back in to the Access Form. ...
5
3556
by: Tmajarov | last post by:
Haven't been able to find a clear answer to this... I am building an asp.net application and trying to enforce some work flow by displaying a form via the showmodaldialog method. I can get the...
0
1932
by: aakash | last post by:
Hello Guys I am upsizing ms access project to give it a ms sql connectivity I am having problem in accessing form control values in ms sql function CREATE FUNCTION "ReportList DateRange"() ...
2
2400
by: Eddie Malone | last post by:
Hi, I'm an access newbie. It is a great little toy and I'm trying to get better at it all the time. I am trying to design a form that will feed into a table. For example sake we will say...
1
1699
by: make1circle | last post by:
Hi all, It's a novice question and hopefully someone could help me out. I've designed an access form for entering patient information. Right now it needs to be modified in the way that the...
1
1488
by: Ste | last post by:
Hi, I would like to have current date automatically enter into a form that is based on a table, so that from report I can tell how many records I have entered for the day. If I use date() on...
4
2866
by: MunaAlBaloshi | last post by:
I am working with MS Access. But I want the date and time be automatically updated in the field. I know that I have to use VB codes. I try to write this code but it is not working. Private Sub...
2
3154
by: beemomo | last post by:
hi everyone! i am using an active x control : date time picker in an access form that bound to date field in a table. Whenever it is displayed on my machine, the control can be displayed and...
1
2685
by: zolamdlankomo | last post by:
(SMALLDATETIME,GETDATE(),20) ...i want the date to be 2010-02-02. wen i run the statement above it gives mt todays dat bt i want 2010-02-02
0
7294
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
7015
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7470
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5602
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5026
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4693
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3183
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3173
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1523
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.