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.
 
Top