All Caps VBA without using Data Validation

[mikejaytlabustro]

Guys I just want to share this VBA code for those who want to
ensure that the data entered is all in capital letters. Just a little
favor, please give me a feedback if it does not work in other Access
versions or if there's possible negative effect in using this code.
I prefer to use this one compared to Data Validation (>CCCCCCC...)
and I tried this already in Access 2007.

======================================================
Private Sub TextboxName_KeyPress(KeyAscii As Integer)
Dim strCharacter As String
strCharacter = Chr(KeyAscii)
KeyAscii = Asc(UCase(strCharacter))
End Sub
======================================================