D DavidSherwood May 10, 2009 #1 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?
J John W. Vinson May 10, 2009 #2 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)
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 May 11, 2009 #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.
J John W. Vinson May 11, 2009 #4 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.
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.