Have a capital letter automatically entered

A

Alex Martinez

Hello,

I have a text box in my form that the user inputs a policy number for
example "P128945" the problem is the user input the policy number as
"p128945" How can I have the first prefix letter be capitalize
automatically when the user inputs the policy number? Any tips will be
appreciated. Thank you in advance.
 
B

BruceM

Someone said:
The point *is* to cause a capital letter.
Click to expand...

Which the > sign accomplishes, at least in my experience. If you use >aaaaa
as the input mask, is it possible to produce anything other than a capital
letter (or a number)?
 
F

fredg

The point *is* to cause a capital letter.
Click to expand...

You really should try it. Write >aaaaaaa as the input mask and try to
enter a lower case letter. You can't.
Actually, if it was my database, I would use the AfteUpdate event as
suggested by Graham Mandeno.
 
S

Someone

You really should try it. Write >aaaaaaa as the input mask and try to
enter a lower case letter. You can't.
Actually, if it was my database, I would use the AfteUpdate event as
suggested by Graham Mandeno.
Click to expand...

<SNIP>

To be honest, either works, but 'a' indicates an optional entry. Presuming
it's not optional, then you'd need 'A'. I offered '0' as the input mask,
because in the example the OP gave after the initial letter, the characters
following it were all numeric. This would have ensured no accidental
letters were entered.

I gave >L to start with because the OP needed to ensure the first character
*had* to be an upper case letter (i.e. not optional).

Anyway, let's not flog a dead horse :)
 
S

Someone

Someone said:
<SNIP>

To be honest, either works, but 'a' indicates an optional entry.
Presuming it's not optional, then you'd need 'A'. I offered '0' as the
input mask, because in the example the OP gave after the initial letter,
the characters following it were all numeric. This would have ensured no
accidental letters were entered.

I gave >L to start with because the OP needed to ensure the first
character *had* to be an upper case letter (i.e. not optional).

Anyway, let's not flog a dead horse :)
Click to expand...

I have an apology to make - I didn't see the > on your initial post.
Sorry!!
 
Top