In Access 2003 , how can I delete entries that I custom defined i.

G

Guest

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!!
 
J

Jeff Boyce

With an Input Mask, you have the option of storing the hyphen or not.
?Perhaps you picked/defaulted to "not"?

Jeff Boyce
<Access MVP>
 

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

Similar Threads

How do I code an e-mail address in an controls input mask? 1
how can remove custom input mask from being an option in the wiz 1
Performing math functions on table entries 1
input mask problem 1
How do I mask SOME characters in a field in Access 2007? 3
Input Mask in Access Table 3
How can I store data as a negative number in Access? 1
how do i validate a field so that only text can be entered? 10

Top