What is the best way to format an ALL UPPERCASE field on a report to the vbProperCase format?
Right now I have a control source with a textbox on a report that looks like this:
="Dear " & [regular title] & ","
So textbox currently looks like this on report:
Dear MR AND MRS STEVEN A HACKSTACKS,
I want it to look like:
Dear Mr. and Mrs Steven A Hackstacks,
I have tried an update query using the STRCONV function. No luck.
I have tried coding the ONFORMAT command. No luck.
I have tried different methods of control source manipulation. No luck.
I know somebody is dying to tell me how easy this is.
Preferably, I do not want to update any table with newly formatted data. If I have to, I will add another field and update to it.
I'm hoping somebody has a VB solution that will function in the report only on that fields format.
Thanks in advance,
Deeky
Start Free Trial
