Input box input mask?

[wh00t]

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?

 

[Geoff Codd]

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

 

[wh00t]

Thanks for the reply but

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

 

[Geoff Codd]

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