mailing labels

[Rick Miller]

I'm attempting to create mailing labels utilizing the
wizard.

When finished with the wizard process I'm prompted by a
box labeled "Enter Parameter Value", requesting a Trim
value. I've entered various values or canceled from this
box.

Then when the label is generated, the lines accessing
multiple fields generate a #Error result. Those lines
combining a single field report correctly.

I've tried modifying the label in the design view but
don't know the proper syntax for the first and last lines.

DESIGN VIEW OF LABEL
=Trim([First name] & " " & [last name])
Business
ADDRESS
=Trim([CITY] & ", " & [ST] & " " & [ZIP])

This yields an error result for the first and last
lines.

I've done this before in earllier versions without
problems. What's the deal?

 

[ardy]

-----Original Message-----
I've tried modifying the label in the design view but
don't know the proper syntax for the first and last lines.

DESIGN VIEW OF LABEL
=Trim([First name] & " " & [last name])
Business
ADDRESS
=Trim([CITY] & ", " & [ST] & " " & [ZIP])

This yields an error result for the first and last
lines.

The syntax appears correct!!!! if you are getting error
on ln1 and 4, the only other problem could be the field
names may be wrong?!?!?!

hope this helps..