Duplicate Record and Phone Number Format

[Angie M.]

Hi,

I have a form with a phone number field. Instead of using formats or input
masks in the table I just formatted the field on the form with a format of
"@@@-@@@-@@@@". Now when I use the Duplicate command button on the form, the
new record has double dashes such as "615-4-42--4111. When I click in the
field the extra dashes go away, when I click off the field they reappear.
I've tried everything - removing the format, putting the format in the field
in the table instead, using an input mask, etc. Any ideas? Thanks

 

[Angie M.]

I figured it out - got rid of the format and added the Input Mask in the
form, not the table. thanks