input

[Josh]

In the criteria of one of the fields in my query I have a
date that I want the user to input. How do I set it up so
that it only allows them to input the date in the format
of dd/mm/yyyy.

Thanks

 

[[MVP] S. Clark]

If you are using a parameter query, then the answer is "you can't".

You can specify the datatype for the parameter to be a date with Query /
Parameters menu choice.

Otherwise, you can build a form, and validate the input to a text box using
the Input Mask.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-