All Caps

K

Kevin D.

Is there a way to make sure that a string of data entered in a form (such as
"bbb") gets stored in the underlying table as "BBB"? I put the ">" in the
format field of the form but that doesn't do it.

Thanks

Kevin D
 
P

Powderfinger

You could put something like this in the AfterUpdate event of all the fields
you want to be in upper case.

If Not IsNull(Me.LastName) Then Me.LastName= UCase(Me.LastName)
 
Top