Input mask on Parameter query

[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

 

[Duane Hookom]

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.

 

[Steve Schapel]

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.