Converting string to proper case

[SidLancing]

I have a report that uses data that was brought into a table containing name & addresses all in upper case. I found an old thread where this was addressed... but I'm too much of a novice to even figure out where that code would go.
my question is where do I put this code

LegalName = StrConv(LegalName, vbProperCase)

where LegalName is the field name ...right now I have this in the "On Activate " part on the report...
when I tried to run it I get the following messge
" you cann't assign a value to this object"

Where do I put this code?

 

[GingerR]

Put it in the RecordSource of the report.

So say your report is based on a table...hit the BUILD button to the right of the RecordSource property (the little button with the three dots on it), and put that calculation in an additional field in the query (use a colon instead, then whatever is on the left of the colon will be the new Field Name).

ProperName: StrConv(LegalName, vbProperCase)

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244