Complex input mask's

  • Thread starter Thread starter Nick W G
  • Start date Start date
N

Nick W G

Is it possible to have an input mask that only allows a
date of birth of people of a certain age. E.G. your not
going to be in pre-school with a date of birth of 12/4/76

If so how is this done.

Many thanks.
 
The simplest way is to use the Validation Rule property for that field in
your table. Just enter:
#12/4/1976#
Click to expand...

or whatever date is appropriate. You can also enter your own text (in the
Validation Text property) for the message that will be produced if an
unacceptable date is entered.
 
Ah, brilliant! Thanks very much.

-----Original Message-----
The simplest way is to use the Validation Rule property for that field in
your table. Just enter:


or whatever date is appropriate. You can also enter your own text (in the
Validation Text property) for the message that will be produced if an
unacceptable date is entered.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX





.
Click to expand...
 
Back
Top