UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Report Generating Blank Pages, Access 2016    
 
   
sruehlen
post Jan 9 2017, 02:32 PM
Post#1



Posts: 1
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?
Go to the top of the page
 
DanielPineault
post Jan 9 2017, 02:42 PM
Post#2


UtterAccess VIP
Posts: 4,692
Joined: 30-June 11



welcome2UA.gif

Has your default printer been changed?


Edit: 2:52
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)?

--------------------
Daniel Pineault
2010-2016 Microsoft MVP
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

Vir sapit qui pauca loquitur
Go to the top of the page
 
GroverParkGeorge
post Jan 9 2017, 02:48 PM
Post#3


UA Admin
Posts: 28,443
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?


--------------------
Go to the top of the page
 
doctor9
post Jan 9 2017, 04:34 PM
Post#4


UtterAccess Editor
Posts: 16,622
Joined: 29-March 05
From: Wisconsin


sruehlen,

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,

Dennis

--------------------
(;,;) 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
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    20th January 2017 - 08:58 AM