G
Guest
I am trying to fortmat a phone number field and need the table to show phone
numbers like (123)456-7890. I am doing something wrong, please help
numbers like (123)456-7890. I am doing something wrong, please help
J
Joseph Meehan
Karen said:
Well, . . What have you done so far?
G
Guest
xRoachx gave very good advice for an input mask. That will work for new
records.
If it's existing records that are wrong, you need to actually change the
data to see the formatting at the table level. If the data is consistent,
like 1234567890, you could format it to look right in queries, forms, and
reports.
However if you are ever doing business with foreign countries, I suggest
forgetting about the format of a phone number. Aside from parts North
America, most other countries phone numbers do not follow any set pattern.
For example my old phone number in England looked like 0869 233123. You will
have troubles trying to get an input mask to work with all the different
formats.
records.
If it's existing records that are wrong, you need to actually change the
data to see the formatting at the table level. If the data is consistent,
like 1234567890, you could format it to look right in queries, forms, and
reports.
However if you are ever doing business with foreign countries, I suggest
forgetting about the format of a phone number. Aside from parts North
America, most other countries phone numbers do not follow any set pattern.
For example my old phone number in England looked like 0869 233123. You will
have troubles trying to get an input mask to work with all the different
formats.
G
Guest
Use an Input Mask -- There is a built-in IM for the phone number. As a note,
it shouldn't matter how the information is viewed in the table but in the
form, query, or report.
it shouldn't matter how the information is viewed in the table but in the
form, query, or report.
G
Guest
Karen:
Using a text field (which allows for leading zeros to be stored as part of
the data, unlike a number data type) set the Format property to:
(@@@)@@@-@@@@
If you wish you can also give it an input mask of:
\(000\)000\-0000;;_
This will show the parentheses and dash in the mask, but not save them as
part of the data.
Ken Sheridan
Stafford, England
Using a text field (which allows for leading zeros to be stored as part of
the data, unlike a number data type) set the Format property to:
(@@@)@@@-@@@@
If you wish you can also give it an input mask of:
\(000\)000\-0000;;_
This will show the parentheses and dash in the mask, but not save them as
part of the data.
Ken Sheridan
Stafford, England