Input Mask

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up an input mask for the following
RMA<space>followed by four or five digits, I need RMA<space> to end up in
the table. I am using "RMA "90000;0 and by either using 4 or 5 "0"'s, I can
make it work, However, I need one mask for either 4 or five digits,
RMA 4500 or RMA 10505

Thank you for your time
 
Use "0" for a required field and "#" for an optional field

Thus #0000 should do the trick

Jim Dublin
 

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

input mask for phone number 2
Suppliers 11
Query works but report has no data 2
Custom, Automated Input Masks 2
Merging data 1
Teach me to Merge Data 2
Access sample database Issue 9
Dlookup to populate sub form 12

Back
Top