How do I use the letter 'L' in an input mask?

M

ml_mills

I need to make an input mask with the following format L1234. The letter L is
has to be on the front. I am having problems because L means any letter in
the input mask - does anyone know how to get around this?
 
D

Daniel Pineault

If you lookup Input Mask or 'Input mask syntax and examples' in the help it
states: "To define one of the following characters as a literal character,
precede that character with a backslash (\).". Therefore you need only to
start your input mask as \L

For your example, you could use an input mask such as:
\L0000;;_
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 

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

Top