It depends on what exactly you mean by "query input box". If you mean the
box that pops up when you write a parameter query like:
select * from Customers where AccountNo=[Give Account Number:]
then the answer is No.
And the workaround would be to create your own form with a textbox to ask
for the parameter, use the format that Mike MacSween gave you, and rewrite
the query as:
select * from Customers where AccountNo=Forms!MyNewForm!MyNewField
-Tom.
"PerryC" <pe******@yahoo.com> wrote in message
news:ea**************************@posting.google.c om...
Is there a way to set a certain format under the Query Criteria for
input?
i.e.: As user type 200000000, 200-00-0000 is displayed in the query
input box. However, 20000000 is the actual value querried. I am not
sure if I make myself clear or not. Thanks in advance.
Sincerely,
Perry