Formatting dates

  • Thread starter Thread starter John S. Ford, MD
  • Start date Start date
J

John S. Ford, MD

I'm using Access 97. If I wanted a user to be able to enter a date into a
TextBox by simply entering a string of numbers as in:

MMDDYYYY

and then hit <return> (or tab) and have the date show up in the TextBox with
backslashes as:

MM/DD/YYYY

how would I do that? Can I do that by creating some type of input mask?

Thanks in advance,
John
 
I'm using Access 97. If I wanted a user to be able to enter a date into a
TextBox by simply entering a string of numbers as in:

MMDDYYYY

and then hit <return> (or tab) and have the date show up in the TextBox with
backslashes as:

MM/DD/YYYY

how would I do that? Can I do that by creating some type of input mask?

Thanks in advance,
John
Click to expand...

Set the Input Mask to

00/00/0000

and the Format property to

mm/dd/yyyy

Access will enter the slashes automatically if you type six digits.
 
If the database user is entering today's date, they can click in the date
field and hit ctrl+semi-colon and today's date will be inserted (as long as
your computer clock is set properly)

Linda
 
Back
Top