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

  • Thread starter Thread starter ccollins
  • Start date Start date
C

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.
 
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.
Click to expand...

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)
 
Back
Top