Need to change an Input Mask in a table.

L

Leslie B

Currently the production table has a field using the following input mask: \M9999999a
Office has changed requirement so that the mask could be M or B. Is there a way to program this without loosing the M

FYI, when I change the mask from \M9999999a to L9999999a I loose the M character in the field

End result: want the data to look like M00012345 or B00012345

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

Similar Threads

Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0
Old data format to new format - Not compatible with old Input Mask 2
input mask on date field 1
Time format hh:nn drops leading zero 0
Formatting text in a table. 6
Input masks 1
Input masks 4
Input Mask in tables 2

Top