Proper capitilization of names

[Today's the Day]

I want to use an update query to capitalize the first
letter of each string and lower case the rest. The trick
is there is a blank between strings within the field such
as with proper names ie. John Doe Smith. I know I need to
use the functions mid, lcase, and ucase in my update
query, but am not quite getting it. Any help would be
appreciated.

 

[Fredg]

The function you want to use is StrConv()

Update YourTable Set YourTable.NameField = StrConv([NameField],3);

Note. This will give incorrect results with names such as McDonald, O'Brien,
van der Steen, Leigh-Taylor, etc.

The way to get these types of names case correct is to use an exceptions
table and run through each name before changing it. You would need a User
Defined function to do this.

Look up StrConv() in Access Help.