Changing CAPS to Lowercase

[Guest]

Hello to all,

Is there a way to run an update query that will change text that's all
capital letters to only capitilize the first letter in each word.

For example, to change:

FIRST BASE to First Base

Our home office sends us databases that are always in all capital letters.
It's as though the words are shouting at us. Egads!

 

[Dan Artuso]

Hi,
Sure, use the StrConv function with vbProperCase (3).

UPDATE yourTable SET yourField = StrConv(yourField,3)

 

[Guest]

Dan,

Thank you very much for your help. Your timely response is greatly
appreciated. I don't know what the world would do without all of you support
techs.

 

[Marshall Barton]

Thank you very much for your help. Your timely response is greatly
appreciated. I don't know what the world would do without all of you support
techs.

Support techs? We don't need no stink'n support techs ;-)

These newsgroups are a community affair, those with answers
help those with questions. Some may have more answers than
others, but that's often just the benefit of more
experience.

Everyone was a beginner at one time or another so keep on
truck'n and you might be able to help out too.

 

[Student Databaser]

Does this also apply to changing lowercase to CAPS? I have a state field
that has some records as mi and others as MI and i want them all to be caps.

Would it simply be

UPDATE yourTable SET yourField = StrConv(yourField,3)

But change the 3 at the end to something else?

 

[John Spencer]

Or you can just use the UCase Function. Which forces everything to Caps
1= Uppercase (Caps)
2= Lowercase
3= Proper Case (First letter of each word in upper case.

StrConv([YourField],1)
or
UCase([YourField])

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Hi -

Take a look at the StrConv() function in your help file. There's a complete
listing of the available arguments.

Bob

Does this also apply to changing lowercase to CAPS? I have a state field
that has some records as mi and others as MI and i want them all to be caps.

Would it simply be

UPDATE yourTable SET yourField = StrConv(yourField,3)

But change the 3 at the end to something else?

Thank you very much for your help. Your timely response is greatly
appreciated. I don't know what the world would do without all of you support

[quoted text clipped - 9 lines]

Everyone was a beginner at one time or another so keep on
truck'n and you might be able to help out too.