case change

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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?
 
"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>

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change text from lower case to upper case in Access 2007 1
Access 2007 1
Change all upper case letters to lower case 2
Case being changed in table 1
Fonts and Case in Excel 1
Change Upper Case to Title Case 1
changing text into uppercase 2
All CAPS in a table 9

Back
Top