PC Review


Reply
Thread Tools Rate Thread

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

 
 
ml_mills
Guest
Posts: n/a
 
      13th Jan 2010
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?
 
Reply With Quote
 
 
 
 
Daniel Pineault
Guest
Posts: n/a
 
      13th Jan 2010
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.



"ml_mills" wrote:

> 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?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
input mask - capitalize first letter? =?Utf-8?B?Z3Jhbm5hc2g=?= Microsoft Access 7 4th Jul 2007 07:08 PM
Input mask specific letter or charater =?Utf-8?B?Sm9obiBL?= Microsoft Access 2 11th Jan 2006 04:40 PM
input mask to capitalise first letter of surname =?Utf-8?B?bWFyZG9o?= Microsoft Access 4 16th Nov 2005 11:04 PM
Input mask to uppercase first letter of names when hyphenated =?Utf-8?B?QmFyNGg=?= Microsoft Access Forms 2 21st May 2005 10:35 PM
Input Mask - Capitalise First Letter ? andyw Microsoft Access 2 25th Oct 2004 05:33 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:51 PM.