create labels from report

[Van T. Dinh]

Also the last expression looks incorrect. My guess is
that it should be:

= Trim([City] & ", " & [State] & " " & [Zip Code])

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
I am trying to create mailing from an Access database and

pulled info from a query to create my address list. When
I'm in the Report and want to preview it a message comes
up asking for my parameter values and on the next line it
says Trim. I've searched the Help section and it does not
address my problem. My design is set up like this:

=Trim([Family Name])
=Trim([Address])
=Trim([City]&","[State]&" "&[Zip Code])

I used the Trim to eliminate the excess spacing due to varying lenghts in the data.

My friend was trying to help me with this and she was not

getting the message asking for Trim on her system. I'm
using Access 2003/Microsoft Office Professional Edition
2003.