All Caps

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top