Formatting City Name

[Tim]

I have a column of city names that I'm including in my
report. They are stored in the table in all capital
letters. I need to display them on the report so that the
first letter of each word is in uppercase and the rest of
the letters in the word are in lowercase. The main
problem that I'm running into here is that many of the
cities have multiple words. For example:
NEW ORLEANS
SOUTH WILLIAMSON
PAGOSA SPRINGS
PLYMOUTH
etc.

Can you help me with a way to format these fields(either
on the report or in the query) so that the names show like
below:
New Orleans
South Williamson
Pagosa Springs
Plymouth

Thanks!

 

[Rick Brandt]

I have a column of city names that I'm including in my
report. They are stored in the table in all capital
letters. I need to display them on the report so that the
first letter of each word is in uppercase and the rest of
the letters in the word are in lowercase. The main
problem that I'm running into here is that many of the
cities have multiple words. For example:
NEW ORLEANS
SOUTH WILLIAMSON
PAGOSA SPRINGS
PLYMOUTH
etc.

Can you help me with a way to format these fields(either
on the report or in the query) so that the names show like
below:
New Orleans
South Williamson
Pagosa Springs
Plymouth

Check the help file for StrConv() function.

StrConv("NEW ORLEANS",3) Returns "New Orleans"