Date Entries

[Phredd]

I have used the [Enter Date Required] criteria format to select the dates for a query.

This prompts the user to enter the date.

How can I set an input mask on this method, or is there a better method of doing this ??

Thanks

 

[bradcccs]

Phredd,

I construct an unbound form for entry of criteria. That way you can use any input mask you wish on each of the unbound objects on the form.

You can then refer to the form in your query criteria statement.

You can also use the criteria form to specify criteria for more than one query. (ie both queries refer to the form - as long as they are not both queried at the same time.)

HTH

Brad.