Formatting Access Reports

[DAPPER]

I am using this expression (=Trim([City] & ", " & [State] & " " & [Zip]) ) to
condense my report output but keep getting an error message. The message is
"This control has a reference to itself." I am stuck at this point as to
what to do.

 

[Rick B]

Where are you putting this expression? In an unbound text box?

 

[Brendan Reynolds]

The text box is probably named 'City', 'State', or 'Zip'. Rename the text
box and you should be OK.

 

[MK]

I did that and this:

=IIf([City] Is Not Null Or [city]<>"",Trim([City]))+IIf([state] Is Not Null
Or [state]<>"",+", "+Trim([State]))+IIf([state] Is Not Null Or [state]<>"",+"
"+Trim([Zip]))

and it works perfectly.