mask on entering parameter value

  • Thread starter Thread starter ljb
  • Start date Start date
L

ljb

I have a query in my database that prompts the user for a "start" date and
an "end" date. These appear in the form of two "Enter Parameter Value"
boxes. Is there a way that I can put a mask on these input boxes to require
an entry of a short date: mm/dd/yyyy?

ie. user can type 010105- which will automatically be translated into
01/01/2005

Thank you in advance for any assistance.

LB
 
No, not as they are now. you would have to create a new form (a pop-up) and
put two unbound fields on that form. You could apply your edits there.
Then, in your query, instead of having a =[Enter Parameter Value] criteria,
you would need to point to the form.

If you do some searches you will find lots of examples out there.

Most of the template databases that come with Access have this feature when
you go to run reports. You might open a couple of the sample databases and
look at how they work if you want more details or some ideas. You could
also copy or import the forms from there and save yourself a lot of time.

Hope that helps,

Rick B
 
Back
Top