Unable to create mailing label in Access

Posted on 2011-04-30
Last Modified: 2012-08-14
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.
Question by:pstewartrrm
    LVL 1

    Expert Comment

    by:G Scott
    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.

    Author Comment

    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.
    LVL 1

    Accepted Solution

    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

    Author Closing Comment

    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.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    This collection of functions covers all the normal rounding methods of just about any numeric value.
    Article by: Leon
    Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now