Converting text case

[Gerry Duggan]

I have imported a table created by another containg a text
field with city names typed in in all upper case. I would
like to design a report that converts the upper case for
the cities (some having three words in the name) where the
first letter is in upper case and the remainder in lower
case.

Would appreciate any suggestions.

Thanks,

Gerry

 

[Paul Johnson]

There is a built-in function called StrConv. Usage is:
StrConv(String, Conversion as VbStringConv, [LocaleID As Long])

The constant for your needs is "vbProperCase," i.e.
StrConv(strMyString, vbProperCase)

HTH
Paul Johnson