I need to set up an input mask for a Date/Time data type
such that it will accept a year only if the month and day
are not available (e.g., __/__/1990). I've tried using
the 99/99/0000 input mask, but it will not accept spaces
for the month and year. If I use a Text data type with a
99/99/0000 input mask, then it will accept spaces but I
lose the ability to limit the month between 01 and 12, and
the day between 01 and 31. Do you have any suggestions?
I'm at a loss!
Thanks!
Jennifer
Steve Schapel - 24 Jun 2004 18:47 GMT
Jennifer
It is not possible to enter a date without all components: day, month,
and year.

Signature
Steve Schapel, Microsoft Access MVP
> I need to set up an input mask for a Date/Time data type
> such that it will accept a year only if the month and day
[quoted text clipped - 9 lines]
>
> Jennifer