Caps lock

[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

 

[Rick B]

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

 

[Jim Allensworth]

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