Hi Bret,

>What is, in general, the best way to handle names capitalization? The simplest way is to expect data entry people to capitalize them correctly, and print them on reports as they appear in the field. That way, no algorithm needs to figure out how to capitalize names like MacDonald, O'Reilly, DiFatta, or ffolkes. However, if someone made a function or lookup table that was comprehensive enough to handle these and other examples, it could make a names table more error free than it would be if left to the data entry person.

Check out the Proper() function and get your ideas from there. Just a note, I hate it when MSWord or something tries to change all my Capitlaizations and Quotes automatically, therfore, at least allow your user an option to enable/disable this behaivor.