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
|
|||
|
|||
In Access 2003 , how can I delete entries that I custom defined i.
I defined an Input Mask entry as !LL0-00 to achieve entries in a text field
with a length of 6 to appear as EN1-80, etc. When I test the Input Mask in the wizard, it appears ___-__ as expected. When I make entries in the affected field in the table, the mask displays the hyphen as I enter all characters. However, when I move to a different record, the new entry based upon the Input Mask deletes the - character, to result in EN180. I attempted to add similar entries in the Input Mask Edit List to troubleshoot, but all result in the same problem. Zip Code or Phone masks that include - work fine. I tried to repair Office, but nothing works!! |
#2
|
|||
|
|||
With an Input Mask, you have the option of storing the hyphen or not.
?Perhaps you picked/defaulted to "not"? Jeff Boyce Access MVP "dianecl1" wrote in message ... I defined an Input Mask entry as !LL0-00 to achieve entries in a text field with a length of 6 to appear as EN1-80, etc. When I test the Input Mask in the wizard, it appears ___-__ as expected. When I make entries in the affected field in the table, the mask displays the hyphen as I enter all characters. However, when I move to a different record, the new entry based upon the Input Mask deletes the - character, to result in EN180. I attempted to add similar entries in the Input Mask Edit List to troubleshoot, but all result in the same problem. Zip Code or Phone masks that include - work fine. I tried to repair Office, but nothing works!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2003 (Ready to throw in the trash) | Patrick Parks | General Discussion | 5 | January 5th, 2005 10:38 PM |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
Access 2003 less functional than Access 97? | George Hester | General Discussion | 2 | June 4th, 2004 04:53 PM |