This was the code that I concocted for the incorrect case
phenomenon. Just thought I would share it with the readers as it seemed to work
well. If you have a better way, let us know.
MyFieldName is the name of the Table field or Form field that we want to change
case on. You can also use the LCase function to change text from upper to lower
Input From Jerry
Why bother checking for lower case? Why not just do it:
Private Sub Form_BeforeUpdate(Cancel As
Seems like simpler code and probably less processing overall. Too bad there isn't an Input Mask code to convert to upper case without specifying the number of characters.
Also I use the following in one form to make everything upper case as it's typed in:
Form_KeyPress(KeyAscii As Integer)
This is nice because it only has to be done once in the form.
Other Pages at VB123.com That You May Want To Visit