Saving text in tables as uppercase from a form's text box

[draaYak]

I have a text box on a form with the > format set so that it converts the text box to uppercase. However, when I save this value into a table, the value is saved as whichever case it was originally entered into the text box. Is there a way to save the value in a table as all uppercase, no matter what the display value is?

FYI I use an SQL string to enter data into my tables so when I press a button, it runs the following code "INSERT INTO (TableName) VALUES (textbox.text)".

Any help would be greatly appreciated.

 

[Newman]

Put your "Format" in the table instead of the form.