How can you format text word capitalization

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?
 
J

John W. Vinson

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)
 
D

DavidSherwood

Thanks. Thank just what I wanted. But its no wonder I could not find it. Its
a bit on the cryptic side.
 
J

John W. Vinson

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