input mask for Date/Time

J

jrlh

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
 
S

Steve Schapel

Jennifer

It is not possible to enter a date without all components: day, month,
and year.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access: Input Mask and Inserting Current Date 1
Input Mask for General Date/Time 1
Time format hh:nn drops leading zero 0
input mask for phone number 2
date+time input mask 3
Conflict with short date and default input mask 1
Date Input Mask - inconsistent displayed value 1
Date format with input masks 2

Top