case change

[yuri789]

How can I change case (lower to upper) in already entered text?

 

[Ken Snell]

You can use the UCase function to convert to all upper case. When do you
want to do this? In the displayed value in the form's textbox? In the
table's field?

For example, you can do this in the display using the control's AfterUpdate
event. Use code similar to this in that event:

Private Sub ControlName_AfterUpdate()
Me.ControlName.Value = UCase(Me.ControlName.Value)
End Sub

Replace generic name of control with real name.

 

[yuri789]

Ken
thank you for the prompt answer. I need to change lower case to upper in the columns that are already populated with text (addresses). Where do I have to run the routine you've mentioned?

 

[Ken Snell]

"Columns" meaning fields in a table?

Run an update query similar to the following:

UPDATE TableName SET [FieldName] = UCase([FieldName]);

Replace TableName and FieldName with the real names.

--
Ken Snell
<MS ACCESS MVP>

Ken,
thank you for the prompt answer. I need to change lower case to upper in

the columns that are already populated with text (addresses). Where do I
have to run the routine you've mentioned?