G
Guest
How can I change case (lower to upper) in already entered text?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
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.
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.
G
Guest
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?
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?
K
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>
have to run the routine you've mentioned?
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>
the columns that are already populated with text (addresses). Where do Iyuri789 said:Ken,
thank you for the prompt answer. I need to change lower case to upper in
have to run the routine you've mentioned?