Date prompt input mask in query

[Zachry1]

During query, i have a Between date parameter. The user gets prompted "Start
Date" then "End date" but neither of these take on the input mask, so the
use has to enter the slashed, ie. "01/01/06". How can I format this prompt
for the input mask?
The table and the field in the query both have the input mask.

 

[Duane Hookom]

Abandon parameter prompts in favor of controls on forms. This allows you to
use combo boxes, calendar forms, formats, input masks, validation,....

 

[HelloWorld]

How is this done ... How do you use the form controls in a query ?

 

[Duane Hookom]

http://www.fontstuff.com/access/acctut08.htm

 

[JetsetA320]

Duane,
I am new to Access but doing pretty good with constructing queries. What
stumps me is that I am intrigued by your preference in avoiding parameter
queries and using controls within a form. I persevered and was finally
rewarded with being able to construct just that. Now I wanted to apply that
to bringing the results of the query instead of a datasheet view to a select
group of forms. That has worked with using the parameter queries before as I
based the form on that query, e.g. Bill Record - BY DATE. I asked for a
'START DATE' and an 'END DATE' which had two parameter pop-ups. But I guess
my question is, "Can a form with controls (as you state) act as a query to
resuits in a group of select forms as a result of that query?" I seem to be
missing something here. If you can point me in the right direction that'd be
great.

JetsetA320