Hi

I have a query which asks the user to enter a date, is there any way I can create an input mask in the input box?

I don't think you can, the way I do it is to create a form with a single unbound text box and set it's input mask as Short Date and also include a calender control so the user can select the date from that and ten in the query criteria I enter the following

[Forms]![Date Selection]![FirstDate]

I find that this looks more professional that the access input box and only takes a few minutes to create

Thanks for the reply but

how does this criteria work is it forms!form name!field name?

the criteria works the sam as if you used an input box,

example: if you enter the date 01/04/02, in the field first date on the form Date selection and create an after update event on the date field or create a button to open the query it will automatically open the query with all records for the date 01/04/02

hope that makes sense