Title Case

[JWT]

Hello,

I have a table with mixed font case entries and want to change the way reports look. I can set the format in the text box to upper “>” or lower”<” but I would like set it for “Title Case” and have not found a setting to do this. Has anyone been able to do this?
Thanks, JWT

 

[Pat Hartman]

Look up the strConv() function. You can use it to convert to proper case. However, it is not 100% perfect so you might want to allow your user to override any modifications.

 

[JWT]

Thanks for the help;

Thanks Pat,

First time working with proper case and did not know which way to go.
Your info put me on track to Microsoft article #ACC2002. I wanted this to change my case on a report and add this to the Queries, Expr1: StrConv([Description],3). In my report I pull the info Expr1: and not from [Description]. If you have a better way do this please let me know. Thanks again JWT