Coverting all caps in a field to proper

[Jeff]

I am using Access 2007 and am having trouble converting a cloumn, which the
text is all caps, to proper - first letter of each word capitalized.

I tried in an update query to run the following StrConv([pub_pvt],3) but all
it did was blank out the text in the column. pub_pvt is the name of the
field I am trying to update.

I look foward to and appricate your help.

 

[fredg]

I am using Access 2007 and am having trouble converting a cloumn, which the
text is all caps, to proper - first letter of each word capitalized.

I tried in an update query to run the following StrConv([pub_pvt],3) but all
it did was blank out the text in the column. pub_pvt is the name of the
field I am trying to update.

I look foward to and appricate your help.

As the function you ran is the correct one, I can only assume you did
something else incorrectly.
How about copying and pasting into a reply message the EXACT query SQL
you used.

Also, be aware that the function improperly removes capitals from some
words that should have more than one capital letter, i.e. O'Brien,
McDonald, IBM, ABC, etc., and also incorrectly capitalizes some words
that should not be capitalized, such as van den Steen, van Beethoven,
abc, e.e. cummings, etc.

 

[John W. Vinson]

I am using Access 2007 and am having trouble converting a cloumn, which the
text is all caps, to proper - first letter of each word capitalized.

I tried in an update query to run the following StrConv([pub_pvt],3) but all
it did was blank out the text in the column. pub_pvt is the name of the
field I am trying to update.

I look foward to and appricate your help.

How did you "run" it? The SQL should be something like

UPDATE tablename SET [pub_pvt]) = StrConv([pub_pvt], 3)
WHERE [pub_pvt] IS NOT NULL;

You'll need to actually RUN the query with the ! icon, or by executing it from
code, or doubleclicking the saved query in the Queries window; just opening it
will show the "pre change" contents.

Back up your database first of course!

 

[Jack Cannon]

Here is a text file that I put together that is intended to act as a library
for words that should be all capitalized or exhibit mixed case. I have put
this in the public domain so that anyone who wishes may use it. It is
intended to be used after the StrConv function is applied. Although it has
745 entries it is most certainly incomplete. In constructing this library I
assumed that certain characters such as the aposthrophe would be removed from
the typed entry.

http://cid-511facbc71d1cd1b.skydrive.live.com/self.aspx/Public/MixedCaseNames.TXT

Jack Cannon

I am using Access 2007 and am having trouble converting a cloumn, which the
text is all caps, to proper - first letter of each word capitalized.

I tried in an update query to run the following StrConv([pub_pvt],3) but all
it did was blank out the text in the column. pub_pvt is the name of the
field I am trying to update.

I look foward to and appricate your help.

As the function you ran is the correct one, I can only assume you did
something else incorrectly.
How about copying and pasting into a reply message the EXACT query SQL
you used.

Also, be aware that the function improperly removes capitals from some
words that should have more than one capital letter, i.e. O'Brien,
McDonald, IBM, ABC, etc., and also incorrectly capitalizes some words
that should not be capitalized, such as van den Steen, van Beethoven,
abc, e.e. cummings, etc.