Changing text to uppercase

[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.

 

[Douglas J. Steele]

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

 

[ruralguy via AccessMonster.com]

Put:

Me.YourControlName = UCase(Me.YourControlName)

in the AfterUpdate event of the control.