Caps lock

  • Thread starter Thread starter LC
  • Start date Start date
L

LC

Hi,

I was wondering if it is possible to make all user type
info into capital letters.

Basically on forms and tables
when the user types in "word" it should automatically
formatted to "WORD"

Thanks in advance,
LC
 
You could use the input mask to convert what they type.

Rick B


Hi,

I was wondering if it is possible to make all user type
info into capital letters.

Basically on forms and tables
when the user types in "word" it should automatically
formatted to "WORD"

Thanks in advance,
LC
 
Hi,

I was wondering if it is possible to make all user type
info into capital letters.

Basically on forms and tables
when the user types in "word" it should automatically
formatted to "WORD"

Thanks in advance,
LC
Click to expand...

You can use the On Key Press event to force upper case.

Private Sub txtMyTextBox_KeyPress(KeyAscii As Integer)
On Error Resume Next
KeyAscii = Asc(UCase(Chr(KeyAscii)))

End Sub


- Jim
 
Back
Top