change case

[DianaD]

I have a table with some records that are all caps and need to change them to proper case. can anyone help with this?

 

[RayH]

strMyString = StrConv(strMyString, vbPropercase)

 

[DianaD]

uh...Wow!!

Ok Ray;
You're going to have to dumb it down a bit for me... I have no idea what you just said...sorry. Can you be a bit more specific. PS. I am from Oregon too!

 

[RayH]

How 'dumb' do I have to go?

strMyString = StrConv(strMyString, vbPropercase)

StrConv is a function that returns a converted string
strMyString is the field your want to convert to 'proper case'
vbProperCase is the code to tell it to do just that.

Do you just want to display the converted field in a form?
In the Current Event of the form use:
Me.strMyString = StrConv(Me.strMyString, vbProperCase)

In a query:
Put in the field part:
MyNewString:StrConv(strMyString,3)

3 is the code for vbProperCase

p.s. Are you enjoying the rain and snow?

 

[Mile-O]

If you just want to change them once and for all you can use an UPDATE query using the StrConv([Field], 3) syntax RayH has stated.

 

[Myriad_Rocker]

Genious...pure genious...

I love this forum