Convert Names to Upper Lower format

[Guest]

I have names/addresses in either all upper or all lower or mixed,. Especially
names like van den STEEN. I need to convert to Van Den Steen. If I use the

L< it only fixes the first section (Van) leaving the others incorrect.

Addresses are even worse since there are a lot of spaces and multiple names
within an address

Somehow at one point I figures it out in an expression in a query but can
not find where I did it, and can not figure it out again.

Any help ismuch appreciated!

Thanks

 

[Guest]

To use in query, try this

strconv(FieldName,3)

And in VBA you can also use this
strconv(FieldName,vbProperCase)

 

[fredg]

I have names/addresses in either all upper or all lower or mixed,. Especially
names like van den STEEN. I need to convert to Van Den Steen. If I use the
Addresses are even worse since there are a lot of spaces and multiple names
within an address

Somehow at one point I figures it out in an expression in a query but can
not find where I did it, and can not figure it out again.

Any help ismuch appreciated!

Thanks

In a query you can use
NewField:StrConv([OldField],3)

However, in all probability, by changing van den Steen to Van Den
Steen you will most probably cause Mr. van den Steen a lot of ill
will, as van den Steen is usually the correct spelling. The same
holds true for McDonald > Mcdonald, O'Brien > O'brien, Smith-Jones >
Smith-jones, etc. Most of us are quite attached to our names and
don't care to see them miss written.