Query Criteria input format - Any possibility to set this?

[PerryC]

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

[Mike MacSween]

Re: Query Criteria input format - Any possibility to set this?

000\-00\-0000;1

"PerryC" <perryche@yahoo .com> wrote in message
news:ea92818f.0 403010924.1202d 6f9@posting.goo gle.com...[color=blue]
> 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[/color]

[Tom van Stiphout]

Re: Query Criteria input format - Any possibility to set this?

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!MyNe wField

-Tom.



"PerryC" <perryche@yahoo .com> wrote in message
news:ea92818f.0 403010924.1202d 6f9@posting.goo gle.com...[color=blue]
> 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[/color]