Phone number formatting

[barbarao]

Hi. SQL back end Access front end. I have a table that contains a phone number field. It has a mask so the phone numbers will have () around the area code. I ran a stored procedure to export some of the demographic fields in that table and some records are not showing the () around the area code while they appear like that on the form the user enters data. Any ideas what might be going on? Thanks in advance.

[Rabbit]

A mask is for display purposes only. Data is not stored with the mask.

[barbarao]

Ah, I didn't know that. I did learn that if you cut and paste into a mask field the mask is over ridden in the table.