I have a query that prompts the user to enter a date. I have an input mask
that is supposed to force the user to enter mm/dd that looks like this:
99/99;0;#
This was generated by right clicking in the criteria box of the birthdate
field, selecting properties, then clicking the elipsis on the input mask
box and going through the input mask wizard. When I test the mask in the
"Try It" box it works as expected. Only letters are accepted and the forward
slash automatically is entered at the third character. When I run the query
and am prompted for the date, I am able to enter letters and there is no
forward slash. Can anyone please help me?
thanks, Ted