>Hi,
>
>I am trying to make it so a form will display phone numbers in the format of (###) ###-####. I want it to do this so it will display correctly regardless of whether or not there are dashes in the data for the phone number. I have tried numerous combinations of Formats and input masks. I know I could simply remove all dashes from the data, but I am hoping to do so without removing them. Does anyone know of a way to get this done?

I am using Input Mask (###) ###-#### and Format R: it displays data as needed, but stores data in the table as ##########.

Regards