[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • 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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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