Find Phone Number in Database

[JRSNHECI]

I am using Access 2007 and have a Contact database. When i use the Find
command to search for a phone number it always tells me there is no such
record found even though the phone number is in the database. I've tried
searching for both the formatted number (i.e. (999) 999-9999) and the
unformatted number (i.e. 9999999999). Any ideas? Thanks.

 

[John W. Vinson]

I am using Access 2007 and have a Contact database. When i use the Find
command to search for a phone number it always tells me there is no such
record found even though the phone number is in the database. I've tried
searching for both the formatted number (i.e. (999) 999-9999) and the
unformatted number (i.e. 9999999999). Any ideas? Thanks.

It's possible that the Phone field in your table is actually a Lookup Field -
in which case what you *see* (the phone number) is not actually stored in your
table; what's stored in the table is a meaningless ID number linked to the
phone table.

What is the actual structure of the table? Are you using a Form? If so, what's
the Control Source of the phone field?

John W. Vinson [MVP]