How can you format text word capitalization

  • Thread starter Thread starter DavidSherwood
  • Start date Start date
D

DavidSherwood

I am importing data that has a text filed in all caps. I would like to covert
it to word cap form. Is this posible?
 
I am importing data that has a text filed in all caps. I would like to covert
it to word cap form. Is this posible?
Click to expand...

If by "word cap" you mean Each Word Capitalized, Including Mistakes Like
Mcneil And O'brien, you can run an update query updating the field to

StrConv([fieldname], 3)
 
Thanks. Thank just what I wanted. But its no wonder I could not find it. Its
a bit on the cryptic side.
 
Thanks. Thank just what I wanted. But its no wonder I could not find it. Its
a bit on the cryptic side.
Click to expand...

That's one of those annoying hidden arcana that someone just has to tell you
about. You're right, it's well hidden and the Help file indexing (or lack
thereof) doesn't help.
 
You must log in or register to reply here.

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

Extract text 1
From large to small letters 4
format a text field 1
New Emails always formatted in capital letters 1
Change all text on Spread sheet 1
I lose the ability to use the Shift or Caps Lock keys in many websites 12
Formatting issue 17
paragraph initial words in small caps 1

Back
Top