Using a format in Select Query

[Guest]

when a form prompts a query to run, and the text box appears asking the user
to enter some sort of data for the query to search for and return,

is it possible to have that query text box formatted to ony accept data in a
certain format?

ie, a form opens and will accept data for a specific customer. When the
query opens, it promts for "Enter Client Phone #"

currently I must type the phone number slowly and carefully to ensure that I
space out the input just as it is saved in the client table format.

Can I set that prompt so that it spaces out the #s and adds brackets and
dashes where required?

 

[Allen Browne]

No. There is no Input Mask for the Parameter box.

The simplest way around this is to create a form with an unbound text box
that has its properties set to the way you want. Then have the query read
the information from the text box. You will end up with something like this
in the Criteria row of your query:
[Forms].[Form1].[Text33]