Converting text case

  • Thread starter Thread starter Gerry Duggan
  • Start date Start date
G

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
 
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
 
Back
Top