Changing text to uppercase

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

Guest

I want to have the data the user inputs change into uppercase on the form and
also the table it is stored in.

I have tried putting the ">" in the Format and that works on the actual
form, but it does not make the data uppercase in the table it is stored in.
Any help would be greatly appreciated. Thanks.
 
Format only changes how the data appears. It has no affect on how the data's
stored.

Try using the UCase function in the form's (not the control's) BeforeUpdate
event:

Private Sub Form_BeforeUpdate()

Me.MyTextBox = UCase(Me.MyTextBox)

End Sub
 
Put:

Me.YourControlName = UCase(Me.YourControlName)

in the AfterUpdate event of the control.
 
Back
Top