How to convert existing text to proper case

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shub - 25 Jun 2006 04:10 GMT

I created a new table by importing the data. The text in some of the fields
are either in upper case or lower case. How do I convert the existing text to
proper case?

Reply to this Message

Al Camp - 25 Jun 2006 05:02 GMT

Shub,
Use the StrConv function. It converts the first letter of every word in a string to
uppercase.
StrConv(string, vbProperCase)

Be aware that strings like macarthur will yield Macarthur... not MacArthur.
MCADAMS yields Mcadams... etc..

Signature

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

>I created a new table by importing the data. The text in some of the fields
> are either in upper case or lower case. How do I convert the existing text to
> proper case?

Reply to this Message

Duane Hookom - 25 Jun 2006 05:09 GMT

If you are doing this conversion in a query, you need to replace
vbProperCase with 3.
StrConv(string, 3)

Signature

Duane Hookom
MS Access MVP

> Shub,
> Use the StrConv function. It converts the first letter of every word in
[quoted text clipped - 10 lines]
>> text to
>> proper case?

Reply to this Message