How can you format text word capitalization

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

 

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

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)

 

[DavidSherwood]

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

 

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

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.