mikejaytlabustro
Access Database 2007 PH
- Local time
- Today, 18:09
- Joined
- Feb 11, 2013
- Messages
- 93
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
======================================================
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
======================================================
