Validation within queries

I'm an A Level Computing student trying to design a system within Microsoft Access. The Problem I am having is as follows:

Within my system I have queries that are related to fields with the use of pop-ups to enter criteria. This is done by entering the criteria with square brackets [] e.g. [enter date] causing a pop up box to appear for the date to be entered for the criteria.

The query works fine but I need to set up validation for the query. Within the table that the query relates to there is an input mask on the field and this works fine when entering information in the table. When the query is run though the input mask does not appear for the pop-up box.

At present the input mask for the table is:99/99/0000;0;_ ...As said this works fine when entering a date into the table but the input mask is not present for the query.



My need is for an input mask or validation rule to work on the pop-up box generated by the query to enter the criteria into.



Many thanks,



Elliot

Not Possible,

You have not control over formating with Pop-ups or input box.

If it is important to you (recongnizing that with dates Access doesn't care, as long as you enter any correct date format, a date is a date), yhen create a form where the user can enter their criteria, and open the query/report from the form, passing the criteria to the query.

S-