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


Report not printing correctly

Posted on 2014-08-26
Medium Priority
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
  • 3
  • 2
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 40287742
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 31

Expert Comment

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

Author Comment

ID: 40287904
I'll try both suggestions tomorrow - thanks
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

LVL 31

Expert Comment

ID: 40288040
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

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

LVL 31

Expert Comment

ID: 40289627

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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.
Suggested Courses

825 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