access 2000

[Francisco]

How Do I Capitalize first letter of every word in a field.

 

[Allen Browne]

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).

 

[Guest]

can that be done in the table