Data Format

[Drew]

I cant seem to keep my phone number masking format - (999)
999-9999 when I have multiple data entry i.e. instead of
having San Francisco, CA: (999) 999-9999, it gives me San
Francisco, CA: 9999999999

Anyone has any idea of how to solve this. Thank you

 

[fredg]

I cant seem to keep my phone number masking format - (999)
999-9999 when I have multiple data entry i.e. instead of
having San Francisco, CA: (999) 999-9999, it gives me San
Francisco, CA: 9999999999

Anyone has any idea of how to solve this. Thank you

You are entering the data in a Form control using the Phone mask, but
you do not have the mask set up to be saved with the data.
(The right characters of your mask are ;; where they should be ;0.

You can change the mask to be saved with FUTURE entries, but you will
need to write an Update query to change existing data.

If all records contain a 10 digit phone number:

Update YourTable Set YourTable.PhoneField = "(" & Left([PhoneField],3)
& ") " & mid([PhoneField],4,3) & "-" & Right([Phonefield],4)

 

[Fons Ponsioen]

After you make the change Fred suggested it is actually
easy to "update" all phone numbers currently onfile.
I would make a copy of the current table so nothing is
lost incase there is some data that does not convert.
Now in the actual table select the column of phone numbers
by clicking in the column header. From edit select copy
and now paste right back, now the data being pasted should
be entered with the new format.
Hope this helps.
Fons

-----Original Message-----

I cant seem to keep my phone number masking format - (999)
999-9999 when I have multiple data entry i.e. instead of
having San Francisco, CA: (999) 999-9999, it gives me San
Francisco, CA: 9999999999

Anyone has any idea of how to solve this. Thank you

You are entering the data in a Form control using the Phone mask, but
you do not have the mask set up to be saved with the data.
(The right characters of your mask are ;; where they should be ;0.

You can change the mask to be saved with FUTURE entries, but you will
need to write an Update query to change existing data.

If all records contain a 10 digit phone number:

Update YourTable Set YourTable.PhoneField = "(" & Left ([PhoneField],3)
& ") " & mid([PhoneField],4,3) & "-" & Right ([Phonefield],4)

--
Fred
Please respond only to this newsgroup.
I do not reply to personal email
.