• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

Unable to create mailing label in Access

I am unable to create labels for the query in the attached database. When I put the "Name" field on the top row I get an "# Error" message with that field only. All the other fields from the query work find. Any ideas? I've done this plenty of times before and have not encountered this situation before.
2011-PayPal-Orders.mdb
0
pstewartrrm
Asked:
pstewartrrm
  • 2
  • 2
1 Solution
 
G ScottCommented:
Why do you use the 'Trim' function in the source of the name field? If you take that out it seems to work. Just wondering what you are using this for.
0
 
pstewartrrmAuthor Commented:
The "Trim" function is being added by the Label Wizard on its own. I did nothing to include it. All I do is select "Name" from the wizard and the "Trim" function is there when I view itl in design view. Is there a setting that needs to be turned off? Although I would prefer not to have to edit the label each time, let me know what the line should look like in design view to have it print correctly.
0
 
G ScottCommented:
If you change the Source of the Name textbox to just Name instead of =Trim([Report]![Name]) then it works fine. Seems to anyway. See below:


 Change this Looks good
0
 
pstewartrrmAuthor Commented:
I ended up changing the field name from "Name" to "Purchaser" and then it worked without a hitch. I noticed that when I tried your solution that I got the name of the query in the "Name" field but I got the person's name in the field when I changed the field name to "Purchaser". Very strange but fixed for now. Thanks for you help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now