Storing a phone number with the symbols

[Guest]

I have my current database storing the phone number without the symbols and I
want it to store it with the symbols. Is there anyway to have it update all
of the information? If not what methods would you use in VBA to get a string
of a certain lenght so I could just write the code that will update it. Thanks

 

[fredg]

I have my current database storing the phone number without the symbols and I
want it to store it with the symbols. Is there anyway to have it update all
of the information? If not what methods would you use in VBA to get a string
of a certain lenght so I could just write the code that will update it. Thanks

This is an international news group.
Are you using U.S. style phone numbers? If so, are they all in the
same form of 10 digits, or are they all 7 digits, or mixed?
Which symbol(s) do you wish to include, the parentheses and hyphen
(212) 123-4567, or are you using the dots 212.123.4567, or do you
just want the hyphen, 212 123-4567.

Run an update query to add which ever symbols you want.
Then change the Input Mask (if you are using one) so that it is saved
with newly entered data.