Report not printing correctly

Posted on 2014-08-26
Last Modified: 2014-08-28
I have an Access 2003 report that was printing correctly but just stopped printing correctly to a specific printer (HP D110). This report prints to an envelope. All other reports in the database (including ones that print to an envelope) print fine. This report prints to other printers correctly. Basically the envelope prints with the characters rotated 90 degrees and with a different, much larger font (images below).

This happened once before and I fixed it but don't remember how. This time, I have uninstalled and reinstalled the D110 printer driver. I exported and imported the report. I changed the report's page setup including changing from landscape to portrait. None of these worked.

Any ideas?

How the envelope prints:
how the envelope prints
How the envelope should look:
how the envelope should look
Question by:thenelson
    LVL 84

    Accepted Solution

    If you've already restored the report from a backup and that hasn't worked, then I'd have to assume either (a) a faulty or corrupt print driver or (b) a corrupt report.

    If it were (a), then other reports would render incorrectly. Since you've indicated that other reports (including "envelope" reports) print okay, then I'd pretty much rule this one out.

    So you may need to recreate the report, unless you can import from a backup you know is good.

    One other thing that comes to mind is a faulty/corrupt user profile. You can test this by logging onto the machine as a different user. If the report renders correctly with the new user, then you may need to recreate the original user profile.
    LVL 30

    Expert Comment

    My only suggestion is to  "recreate the report" and comment back.
    LVL 39

    Author Comment

    I'll try both suggestions tomorrow - thanks
    LVL 30

    Expert Comment

    My comment was based on this analysis:

    1. [this repor] + [this printer] = False
    2. [this report] + [other printer] =True
    3. [other report]  + [this printer] = True

    Steps 1+2 suggest a  problem in this printer, but Step 3 directs us to rule that out.

    Then suspecting the report is a partially option.

    Idea to try:
    You may recreate this report, but not from scratch.
    1. Copy a working  [other report]
    2. Save  to a new name [tempReportnn] , where nn is the version number 01, 02, 03, ...
    2. Modify this new copy with little changes.
    3. Check this new copy after each modification.
    4. If it works  GoTo 2, until you get to the [this report],
        otherwise compare the the current report with the last saved one.
    LVL 39

    Author Comment

    I created a new, blank report. Copied the controls and code from the old "bad" report. The new report is working fine.

    LVL 30

    Expert Comment


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    728 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

    16 Experts available now in Live!

    Get 1:1 Help Now