finding a telephone number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Do you also have an Input Mask set up - perhaps just with spaces? If
you do, is the field set to store the mask characters with the data?
If there is no input mask, looking for "4567890" in your field should
work, though looking for "456-7890" shouldn't.

Parenthetically, it is probably not generally a good idea to keep area
codes in one field with phone numbers - they probably deserve their
own field. One often wants to handle (input and output) numbers with
the local area code (or sometimes codes) differently to long distance
ones, and this is _much_ easier if you store the area codes
separately.

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
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Thanks Peter. My Format is (@@@) @@@-@@@@ and my input mak is blank.

I'll play with it some more.

Richard
 
One fairly obvious question - have you looked at the Table where the
number is stored to see exactly what is there?

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

I'll play with it some more.

Richard
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
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"
 
I was being even more literal-minded than that - what do you see if
you look at the _data_ in the table, in datasheet view?

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"
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top