Upper case conversion

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

Guest

I have a test box on access, and it contains lastnames. I would like to be
able to have that box change everything to uppercase regardless of how I type
in it. How do I make a test box in Access convert everything to uppercase?

Thanks
 
In the Input Mask property of the text box, put >CCCCCC
That would be enough Cs for the maximum length you allow in the text box.
The C allows optional input of any character. If you need different
formatting then put your cursor in the Input Mask property text box and press
F1.
 
Guru said:
I have a test box on access, and it contains lastnames. I would like
to be able to have that box change everything to uppercase regardless
of how I type in it. How do I make a test box in Access convert
everything to uppercase?

Thanks
Click to expand...

In the KeyPress event of the TextBox...

KeyAscii = Asc(UCase(Chr(KeyAscii)))
 
I have a test box on access, and it contains lastnames. I would like to be
able to have that box change everything to uppercase regardless of how I type
in it. How do I make a test box in Access convert everything to uppercase?

Thanks
Click to expand...

Let Access take care of it for you.
Code the LastName AfterUpdate event:

Me![LastName] = UCase([LastName])

Enter the text anyway you wish. Access will then make it upper case
when you exit the control.
 
Back
Top