force lower case
Posted on 2010-11-16
Windows XP, Access 2003, Novice Access and VB user.
I have a form that has unbound controls. When a user types information into various text boxes I am using the click event of a button to write data to different tables.
The information stored in the tables at a later date has to be exported to be used as input data for an ASP hosted system. The ASP hosted system is looking for and requires lower case data.
My question is how do I force lower case on my form so that it is then stored in my table as lower case?
In the property box I tried setting the format of each text box control to format <
I also tried on the KeyPress event of the form the following:
Private Sub Form_KeyPress(KeyAscii As Integer)
'Convert to lower case
KeyAscii = Asc(LCase(Chr(KeyAscii)))
And visually on the form if I test these and I have my caps lock on an type they are converted to lower case. Yet when I open my table the data is in upper case.
What do I need to do in order for the data to be stored in the table as lower case? If possible I would like to do this at the form level and not have to add an additional step of using an update query.
Thanks in advance.