date format for a query field

[roger]

Hello friends:
How would I enter a format of eg. 03/02/2003 for a prompt
which come up for a query..at run time. This is to see to
it that the user enters the format above only for entering
the dates and nothing else.

 

[John Vinson]

Hello friends:
How would I enter a format of eg. 03/02/2003 for a prompt
which come up for a query..at run time. This is to see to
it that the user enters the format above only for entering
the dates and nothing else.

A Format property controls what's displayed, not what's entered; to
control how users enter data you need an Input Mask property of

00/00/0000

However, I *really* dislike input masks on dates - Access is pretty
good at interpreting dates, and the user could enter this date by
typing 3/2 instead of having to hit eight keystrokes 03022003 (with
the input mask filling in the slashes).