Capitalize each word in a field

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

1. Open the table.
2. Select Start Editing from the Table menu.
3. Select the field heading of the field that you want to capitalize.
4. Select Calculate from the Field menu.
5. Double-click on the field name to be converted from the Fields list.
6. Set the Type to String.
7. Scroll down the Requests list and double-click on Proper.
8. Click OK.
   The final expression should look similar to this:

   Code:
   [UPCASEfld].Proper

9. Select Stop Editing from the Table menu and Save your Edits.