lower case / upper case

[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

 

[John W. Vinson]

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

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.