2 digit year for date input mask

[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

 

[T.]

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.

 

[John Vinson]

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

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