lower case / upper case

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

Have a situation that requires any one who types a revision into a field to
make any and all letters lowercase. I am putting KeyAscii =
ASC(LCase(Chr(KeyAscii)))
in the field but needed to verify this is correct plus which event would be
the best to put it in?
Thanks.
John
 
Have a situation that requires any one who types a revision into a field to
make any and all letters lowercase. I am putting KeyAscii =
ASC(LCase(Chr(KeyAscii)))
in the field but needed to verify this is correct plus which event would be
the best to put it in?
Thanks.
John
Click to expand...

I'd suggest simply lowercasing the entire textbox in its AfterUpdate event:

Private Sub textboxname_AfterUpdate()
Me!textboxname = LCase(Me!textboxname)
End Sub

Your event code might be appropriate in the OnKey event but it's (IMO)
overkill for the situation.
 
Back
Top