all caps

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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
 
Back
Top