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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I lose the ability to use the Shift or Caps Lock keys in many websites 12
Table set up 5
New Emails always formatted in capital letters 1
From large to small letters 4
Changing all caps to proper 7
Oledb provider connection pool 0
SOLVED! Allow Autocorrect is the culprit when caps lock fouls up AutoExpand in combo boxes 0
Transforming many cells of all caps into first letter capitals onl 5

Back
Top