Parameter Query with Input Mask

K

Kerry

Is is possible to have a parameter query with an input
mask for the field that you're prompted to type
information into? For example, SSN#. If so, how would you
do it?
 
F

fredg

Is is possible to have a parameter query with an input
mask for the field that you're prompted to type
information into? For example, SSN#. If so, how would you
do it?
Click to expand...

Not with the query prompt, but if you add an unbound control to a
form, you can use, as query criteria:

forms!FormName!ControlName

The form must remain open when the query is run.
 
Top