By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,306 Members | 1,673 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,306 IT Pros & Developers. It's quick & easy.

Query Criteria input format - Any possibility to set this?

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
000\-00\-0000;1

"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

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.