How do I use vbPropercase?

Icehousman2

Registered User.
Local time
Yesterday, 19:28
Joined
May 12, 2004
Messages
45
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!
 
You can try the numerical vale of vbProperCase as in: -

StrConv([tblFieldName],3)

Hope that helps.

Regards,
Chris.
 
ChrisO you are a genius. Thanks for the help it worked great.
 
Can’t be a genius if I leave the ‘U’ out of value… :o

Anyhow, glad it worked. :)

Regards,
Chris.
 

Users who are viewing this thread

Back
Top Bottom