2 digit year for date input mask

  • Thread starter Thread starter Jade
  • Start date Start date
J

Jade

I have a date field on a form that I need users to fill
out. I want them to only have to enter a 2 digit year.
I figured out how to write the input mask so you only
have to type a 2 digit year, but after it's typed and
they move to the next field, it displays a 4 digit year.
This confuses them when entering the next record. The
input mask I'm using is: 99/99/00. Thanks for the help
in advance!

Jade
 
I would suggest looking at the table this date is being stored in. In
design view set the format of the Date/Time field to Medium Date. I use
this in all my forms and it works well. Users enter 04/03/23 and it
displays 23-Mar-04.

HTH,

T.
 
I have a date field on a form that I need users to fill
out. I want them to only have to enter a 2 digit year.
I figured out how to write the input mask so you only
have to type a 2 digit year, but after it's typed and
they move to the next field, it displays a 4 digit year.
This confuses them when entering the next record. The
input mask I'm using is: 99/99/00. Thanks for the help
in advance!

Jade
Click to expand...

Set the Format property of the field as well, to display a two digit
year.
 
Back
Top