Input Mask for dates

[BobRoyAce]

I have a text box on my form that is linked to a data field in my
datasource. I would like to specify an input mask that would allow either
single or double-digit months and days, and either two- or four-digit years.
What could I use for an InputMask to accomplish this?

 

[John Vinson]

I have a text box on my form that is linked to a data field in my
datasource. I would like to specify an input mask that would allow either
single or double-digit months and days, and either two- or four-digit years.
What could I use for an InputMask to accomplish this?

No Mask at all, I'd suggest. An input mask has only one function - to
constrain the user's options to the one the designer allows.

Access is pretty clever at correctly (usually correctly anyway :-{( )
parsing anything that looks like a date into a valid date/time field;
it's quite possible for the user to enter

9/5/04
09-05-2004
Sept 5
9/5
2004.09.05

and have all of them correctly converted to the same date/time value.

John W. Vinson[MVP]
(no longer chatting for now)