Displaying phone numbers

[MaineLady]

I have three fields in a database with phone numbers. They all appear to be set up the same. They all display the phone number format (xxx) xxx-xxxx when data is entered. One of them looks like a phone number in tables, forms and queries. The other two display as a 10 digit number.

What am I missing?

[burrina]

Most likely a format issue. Check your format and data type settings.

[MaineLady]

Thank you... It was the formatting.