Summary
You can use the Proper request to change the first letter of each word in a string to upper case and change all other letters to lower case.
Procedure
- Open the table.
- Select Start Editing from the Table menu.
- Select the field heading of the field that you want to capitalize.
- Select Calculate from the Field menu.
- Double-click on the field name to be converted from the Fields list.
- Set the Type to String.
- Scroll down the Requests list and double-click on Proper.
- Click OK.
The final expression should look similar to this:
Code:
[UPCASEfld].Proper
- Select Stop Editing from the Table menu and Save your Edits.