If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Duplicate Record and Phone Number Format
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 |
#2
|
|||
|
|||
Duplicate Record and Phone Number Format
I figured it out - got rid of the format and added the Input Mask in the
form, not the table. thanks "Angie M." wrote: 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 |
Thread Tools | |
Display Modes | |
|
|