How Do I Capitalize first letter of every word in a field.
A Allen Browne Dec 4, 2003 #2 In the AfterUpdate event procedure of the field: Me.MyField = StrConv(Me.MyField, vbProperCase) Some people may not be happy with the result, e.g. Mcdonald, O'brien, Van Leen (may be van Leen).
In the AfterUpdate event procedure of the field: Me.MyField = StrConv(Me.MyField, vbProperCase) Some people may not be happy with the result, e.g. Mcdonald, O'brien, Van Leen (may be van Leen).