finding a telephone number

R

Richard

On my form, I have a text box where I enter a telephone number. I have the
format set so after typing it in, it will format the information as: (123)
456-7890

But when I try and find a phone number, I can't. For some reason, if I try
and find "any part of" and type 456-7890 or 4567890, Access will not find
this record. My only option is to merely search for 7890.

Is this a common problem or is there something I am missing?

thanks

Richard
 
R

Richard

Thanks Peter. My Format is (@@@) @@@-@@@@ and my input mak is blank.

I'll play with it some more.

Richard
 
R

Richard

I double checked that in the table too. The format is set to (@@@) @@@-@@@
and the field length is set to 15. The input mask is blank. I even clicked
into it to make sure.

Its kind of wierd. If I search for 123-4567, it cant find it. I search for
1234567 and it still cant find it. I search for either 123 or 4567, then it
can find it. All tree times, the search is set for matching "any part of
field"
 
Top