How do I use vbPropercase?

[Icehousman2]

I have some fields that are in all uppercase, but I want them to show up on my report with only the first letter of each word in uppercase. I have heard that vbPropercase will do this, but can I use this in the expression builder of a query. I tried using StrConv([tblFieldName],vbPropercase). But this isn't working. Someone help please!

 

[ChrisO]

You can try the numerical vale of vbProperCase as in: -

StrConv([tblFieldName],3)

Hope that helps.

Regards,
Chris.

 

[Icehousman2]

ChrisO you are a genius. Thanks for the help it worked great.

 

[ChrisO]

Can’t be a genius if I leave the ‘U’ out of value…

Anyhow, glad it worked.

Regards,
Chris.