Create input mask AFTER data has been entered in wrong format?

[ccollins]

Using Access 2007: Is it possible to create an input mask for a Telephone
Number field after you have imported data into a table in the wrong format?
For example, some data was imported in this form: 123.456.7891 but I need to
know if the system can correct it to read (123) 456-7891.

 

[pietlinden]

Using Access 2007: Is it possible to create an input mask for a Telephone
Number field after you have imported data into a table in the wrong format?  
For example, some data was imported in this form: 123.456.7891 but I needto
know if the system can correct it to read (123) 456-7891.

you would have to run an update query. Especially if you want to
store the data formatted.

something like
"(" & left$(phoneNo,3) & ") " & mid$(phoneNo,5,3) & "-" & right$
(phoneNo,4)