global text change

[BBran]

Hello,

I am using Access 2007 as part of Office 2007 on XPSP2. Can anyone tell me if there is a way to globally change all text in a field
from caps to initial caps, without doing it one word at a time? For example DEER CREEK to Deer Creek and BIG CREEK to Big Creek? I
have been doing it using an update query for each all caps string, but that is going to take forever, one string at a time.

 

[John Spencer]

Have you looked at the StrConv function.

StrConv("AB COMPANY INC",3) returns Ab Company Inc

Of course it does have problems since it has no intelligence other than making
all letters lower case except the first letter in the string and any letters
that follow a space which are capitalized.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[BBran]

Thank you so much, that saved me all kinds of time! I was going through one at a time cut and pasting using a spell checker in
WordPerfect. I just did an update query using StrConv([Elk Survey Data]![DRAINAGE],3) and Is Not Null as the criteria and it fixed
all the names.

Thanks Much!
Bob







Have you looked at the StrConv function.

StrConv("AB COMPANY INC",3) returns Ab Company Inc

Of course it does have problems since it has no intelligence other than making
all letters lower case except the first letter in the string and any letters
that follow a space which are capitalized.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[De Jager]

Hello,

I am using Access 2007 as part of Office 2007 on XPSP2. Can anyone tell
me if there is a way to globally change all text in a field
from caps to initial caps, without doing it one word at a time? For
example DEER CREEK to Deer Creek and BIG CREEK to Big Creek? I
have been doing it using an update query for each all caps string, but
that is going to take forever, one string at a time.