Convert to Proper Case

[JohnLee]

Hi,

I hoping someone might know what expression I need to create to convert text in a field in an append query to proper case.

The reason for this is that I am receiving data in all uppercase and really need it to be in proper case, that is only the first character of each word in the field is capitalised.

A field name for instance is strProductDescription and I want the data to change from "FRIDGE FREEZER" to "Fridge Freezer" on appending the data to another table, hence a proper case function or expresssion.

Any assistance would be most appreciated.

John

 

[KenHigg]

See if this helps:

http://www.access-programmers.co.uk/forums/showthread.php?t=136162&highlight=proper+case

 

[Mike375]

StrConv([ProductDescription],3)

The "3" is for conversion to upper and lower case

 

[JohnLee]

Thanks KenHigg and Mike375

for your responses, Mike375 I used your expression which worked great, thanks very much

John

 

[KenHigg]

I be darn, I forgot that - Thanks Mike.

 

[boblarson]

The "3" is for conversion to upper and lower case

Which, of course, is known as "proper case."

 

[doakey]

Can I make a macro to convert to prper case.

 

[doakey]

In my database in access 2007 the visual basics does not work, how do I enable it.?
Dave

 

[John Big Booty]

Is your DB in a Trusted Location?

 

[doakey]

I Made a copy and saved it to drive\Program Files\Microsoft Office\Templates it made it read only, but made me a copy which went back to my original file, but still the same piroblem, no vba.

 

[doakey]

Thanks John
Working now, made my holding file a trusted file
Dave