date field format for a query

R

roger

Hello friends:
How would I enter a format of eg. 03/02/2003 for a prompt
which come up for a query..at run time. This is to see to
it that the user enters the format above only for entering
the dates and nothing else.
 
K

Ken Snell

Is 03/02/2003 the same as March 2, 2003? or as February 3, 2003?

If you're using a parameter box that the query generates, you cannot control
the format that the user uses. However, ACCESS will expect the format to be
in mm/dd/yyyy format.

What you need to do is to create your own form with a textbox on it, use an
input mask if you wish, and the run the query from a command button on the
form; let the query pull its value from the form instead of from a parameter
box. You reference the control on the form this way:
[Forms]![FormName]![TextBoxName]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
ASK Field Formatting 1
VBA - exporting serial letters to single documents 0
Pass date from one form to another form in MS Access 1
Parameter Query 5
Conditional formatting with dates 7
Some mail merge fields not pulling into document 2
date field format for a query field 2

Top