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.

On Jan 22, 9:39*am, ccollins <ccoll...@discussions.microsoft.com>
wrote:
> 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)