Complex input mask's

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.
 
C

Cheryl Fischer

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

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.
 
G

Guest

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





.
 

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

Top