Report Generating Blank Pages, Access 2016
Jan 9 2017, 02:32 PM
Joined: 9-January 17
Using Access 2016 database daily to create a report. Report has been working fine. Today, all of the sudden Access is inserting a blank page between each page of the report. No changes were made to the database overnight. Is anyone experiencing this same issue starting today?
Jan 9 2017, 02:42 PM
Joined: 30-June 11
Has your default printer been changed?
Since we just entered a New Year, could there be a WHERE clause etc that is having an issue due to the New Year? Just a thought.
Have you performed a compact & repair of your BE and FE (make backups prior)?
Jan 9 2017, 02:48 PM
Joined: 20-June 02
From: Newcastle, WA
Welcome to UtterAccess.
When a change in behavior appears without any (apparent) change in environment, the first thing I look at is data. Is the data in this current report different in any way? Are there nulls, for example, or fields which are longer and therefore causing controls to increase in height? If this report has been in use for months, or years, has it always been consistent? Or is this a relatively new report that might just now be including data that wasn't included before?
Jan 9 2017, 04:34 PM
Joined: 29-March 05
Often a blank page every other page is a sign that your report's design is too wide to be printed on the selected printer. Some printers have narrower tolerances for how close to the edge they can print. I'm guessing that your report's width is just a bit too wide to fit within the printer's tolerances. What are your left/right margin widths? What's the width of the report, and what size paper are you using?
Hope this helps,
(;,;) Li'l Cthulu says: Please talk about what you're trying to do, as well as how you're doing it.
Changing your real table name to "Table1" and your real form name to "Form1" in your posts makes it more difficult to understand what's going on, not easier.
Guidelines for Posting Questions
|Search Top Lo-Fi||20th January 2017 - 08:58 AM|