Access 2003 report printing
We've been using Access 2003 for a while and are now changing over to 2007. At the same time, I am creating a new report to replace a report we've used in a database successfully for several years. I open the new report, and it looks perfect on screen, then I print it using the printer icon. The printer totally freezes up, to the point I have to turn it off and back on. I took out most of the labels, text boxes, lines, etc, trying to zero in on which item is causing the problem. Haven't quite determined that yet, but this question has to do with the print version coming out different than the screen version even when it works. For instance, I have a label on the report with the caption "Application Date:" In the print version, it says "Application ate:" with the "D" missing. In another label, there is a lower case d that prints out as a strange little symbol or something. Any guesses on where to look to find why the print version is not matching the screen version?
Software/Hardware used:
Access 2007
Software/Hardware used:
Access 2007
ASKED:
March 10, 2011 6:15 PM
UPDATED:
April 12, 2011 12:28 AM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
I found some additional information. I printed the report to a different printer and found out it comes out OK. So the report prints OK on two table top size lasers but not OK on two floor sized Kyocera’s. We use the Kyocera’s for everything else, including printing Access reports. Now I have a work-around but am still puzzled.
Sometimes certain printers seem to be confused by too much data. Perhaps now the report as it is literally sent to the printer is much larger due to changes in Access and the printer may not have sufficient memory to handle that.
You might try various options in the printer’s configuration in order to test this, such as setting fonts to download as bitmaps, printing in low memory mode, install updated drivers, etc. I can’t say that’s your issue, but I have had similar issues from all of those same reasons.