all caps

all caps

Post by RGF2aWQgU » Thu, 08 Mar 2007 07:33:11


I imported a database from another application. It came in as ALL CAPS. I am
using it to send out letters and would like to have the correct
capitalization.
--
David P
 
 
 

all caps

Post by Jeff Boyc » Thu, 08 Mar 2007 09:33:34

David

Take a look at using the StrConv() function in a query. The vbProperCase
(3) setting will capitalize the first letter of each word ...

WARNING! JEAN CLAUDE VANDAMME and RONALD MCDONALD will be converted to Jean
Claude Vandamme and Ronald Mcdonald...

You may have to rely on USB (using someone's brain) to verify that the
conversion worked as expected.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP