The command you're looking for is StrConv using the vbProperCase constant.
It will change the first letter of each word to upper case and change all
other letters to lower case.
--
Wayne Morgan
MS Access MVP
"Gregjg" <gr**@brabble.com> wrote in message
news:7d**************************@posting.google.c om...
I have table with a field named for a city. Is it possible for the
entries to auto uppercase the first letter? I know > will format all
upper case and < lower case. But is there one for "proper"?