English

How To: Convert upper case words to lower case in a string field

Summary

You can use the Lcase request to change all characters in a string field 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 change to lower case.
  4. Click the Field Calculator button.
    [O-Image] Field Calculator Button
  5. Double-click the field name to convert from the Fields list.
  6. Scroll down the Requests list and double-click Lcase.
  7. Click OK.

    Note:
    The final expression should look similar to this:

    Code:
    [State_name].LCase


  8. Select Stop Editing from the Table menu.
  9. Save your Edits when prompted.