Duplicate Record and Phone Number Format

A

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
 
A

Angie M.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top