Input mask on Parameter query

  • Thread starter Thread starter George Wilson
  • Start date Start date
G

George Wilson

I am using a parameter query to generate a report and I
would like to force an input mask on the parameter. I can
set an input mask to the field but not to the pop-up box
for parameter input. Is there an expression I can use in
the query criteria to force and input mask on the
parameter?
TIA
George
 
You should consider moving away from parameter prompts since they are not
very functional. You should instead, use a reference to a control on a form.
This allows you to set input masks, check integrity, provide drop-down
lists, etc.
 
George,

As far as I know, there is no way to do this directly with a parameter
prompt.

Instead of a Parameter Query, you could put an unbound textbox on a
form, where the user will enter the criteria before opening the report.
Then you can either refer to this control in the query criteria using
syntax such as [Forms]![NameOfFrom]![NameOfCriteriaTextbox], or else you
can refer to this textbox in the Where Condition argument of the
macro/code you use to run the report. In this case, you could apply an
Input Mask to the textbox.
 
Back
Top