Instructions provided describe how to use the Field Calculator in ArcMap to capitalize the first letter of all the values of a text or string field in the Attribute Table.
The procedure described below is for Version 9.3x and earlier.
Optionally, create a new text field for the result by first clicking Options > Add Field.
Dim sUpperC As String
sUpperC = LEFT( [FIELD_NAME], 1)
Dim sLowerC As String
sLowerC = RIGHT( [FIELD_NAME], LEN( [FIELD_NAME]) - 1)
Dim Output As String
Output = UCASE(sUpperC) & sLowerC