Take a look at using the StrConv() function in a query. The vbProperCase
(3) setting will capitalize the first letter of each word ...
WARNING! JEAN CLAUDE VANDAMME and RONALD MCDONALD will be converted to Jean
Claude Vandamme and Ronald Mcdonald...
You may have to rely on USB (using someone's brain) to verify that the
conversion worked as expected.
Microsoft Office/Access MVP