You'll have to first decide how you want to store phone numbers and make them all the same format. I would recomend to
store digits only so later phone number can be formatted for input/output the way you want. In your case you would set Format= "R" and InputMask = "(###) ###-####".
>
>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?
--sb--