Changing CAPS to Lowercase

S

Sky Warren

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

Dan Artuso

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

UPDATE yourTable SET yourField = StrConv(yourField,3)
 
S

Sky Warren

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

Marshall Barton

Sky said:
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.
Click to expand...


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

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

raskew via AccessMonster.com

Hi -

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

Bob

Student said:
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?
[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.
Click to expand...
Click to expand...
 
J

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

Student said:
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
Click to expand...
[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.
Click to expand...
Click to expand...
Click to expand...
 
Top