Phone # does not display the way I want it.

Jeanette

Registered User.
Local time
Today, 06:43
Joined
Dec 17, 2001
Messages
52
Hi, I have a Borrower Table with a Phone# Field. The Input mask is set so that the data displays like (000) 000-0000. The primary key field which is a combination of letters and or numbers was changed for some of the records. For records that have new Primary Key ID# the Phone# Field now displays like 0000000000 instead of this (000) 000-0000 in queries where Phone# field is a output column. I do not know why this is happening. Can anyone help. Thanks in advance.
 
Trying inputting just numbers, i.e, 80055511212, then format your use of the number with (@@@) @@@-@@@@.
 

Users who are viewing this thread

Back
Top Bottom