INPUT MASK, Please help.

[Guest]

Dear all,

Can anyone help me to set up the input mask for my text field? This field
could be 123.99, or V12.45, or 123.2.

My point is : the length of this field will be 6. the first character could
be number or char, the second and third will be number, the . must always be
there, the last two number are optional.

Thank you for help

Blinda

 

[Guest]

Hi, Blinda.

Try this input mask:

A00.##

(That's two zeros, not O's.)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

 

[Guest]

Thank you. It works. I did a little change. I used

A99.99

Thanks.

Blinda

 

['69 Camaro]

You're welcome.

I did a little change. I used

A99.99

Oh. I didn't realize that you wanted the four digits to be optional and
wanted to allow spaces.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.