Update existing data to match input mask

[acrowe97]

I have a table where I have phone numbers stored as XXX-XXX-XXXX, but i need them to match the new input mask of (XXX) XXX-XXXX. Is there a way to update all the numbers without doing it individually?

[GinaWhipp]

Hmm, well I normally store them in the Table without a mask and then use the mask on the Form to display it the way I want to see it. Is that an option for you?

[acrowe97]

I have the mask on the form and table, but I had imported the phone numbers prior to implementing the mask. When i go into the form the mask does not get applied to the table info, is there a way I can change that?

[Gicu]

Just run an update query and use the Replace function: Replace([YourPhoneNumberFieldName],Left([YourPhoneNumberFieldName],4),"(" & Left([YourPhoneNumberFieldName],3) & ") ").
Cheers,
Vlad

[GinaWhipp]

Tell me why that matters? The table just holds the data much like a bucket of water. No one should be using the table.

[acrowe97]

Thank you so much! Worked like a charm.