Find Phone Number in Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JRSNHECI - 19 Jun 2007 21:05 GMT

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.

Reply to this Message

John W. Vinson - 20 Jun 2007 01:02 GMT

>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]

Reply to this Message