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

Would appreciate any suggestions.



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)

Paul Johnson

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question