sql - access forms: forcing UCASE in a textbox -

I would like to immediately force the text box to immediately replace the UCAS as if the user is away from the field it's possible?

The important thing is that this lesson will be used in the SQL query to update a table.

After updating the text box on the form, just go:

 < Code> If isnull (me.MyTextBox) = wrong then mine. MyTextBox = ucase (Me.MyTextbos) End if  

You can also specify the input mask on the form.

"> LLLLLLL"

Above all ">" will force all characters to type upper case. The number of L is any four mask (and, you do not need around the input mask)