Solved

First Page of MultiPage document prints blank but looks fine in Preview

Posted on 2014-01-28
3
429 Views
Last Modified: 2014-01-31
I've set up a multi page report/document for my client.  Each of the 5 pages has its own unique verbiage and pulls different fields from my DB.

Based on advice from EE I created a main report that has all five pages as subforms.  It had been printing fine but I got word this morning that the first page is a blank sheet of paper.  The next 4 print as they should.

I first put the report on the screen in preview mode and everything looks perfect.  All five pages formatted as they should.  It's only use they use the Print... option, selecting all pages to print that this problem occurs.

I suggested as a temporary work around to just print page 1 of 1 in the print dialog box, but that prints a blank sheet of paper also.

I verifed that the margins ares correctly on every individual report/page and on the overall report that holds all five subforms.
0
Comment
Question by:mlcktmguy
  • 2
3 Comments
 
LVL 1

Author Comment

by:mlcktmguy
Comment Utility
More info,  I was going to suggest that they export to snapshot format and print that.  Snapshot best preserves the formatting.  That didn't work though, first page is blank when exported as snapshot also.

I also0 set the Visible property to No for all report heades and footers since there is nothing in them anyway.  Still had the same result.
0
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
Comment Utility
The report may be corrupted.  If you have one from a backup, see if it works.  If the old copy works, try the usual compact and repair/decompile/copy all objects into a new empty database to see if you can get rid of the corruption.

If there is a code module to the report, copy the code into notepad and then delete it from the report.  Compact and repair.  Then paste the code back.
0
 
LVL 1

Author Comment

by:mlcktmguy
Comment Utility
Since posting the issue I discovered what was causing it but I'm keeping the question open because I still don't have a resolution.

Prior to today's release, when the users entered a payment plan for a customer three report/documents were generated in preview mode.  An agreement, a cover letter and payment coupons.  All generated on standard paper in portrait mode.  Everything was cool.

The user requested that an account statement also be generated with the three other documents.  I added the generation of the account statement to this process.  The account statement prints in landscape mode.  That was the only change I made.  After that, all documents looked fine in preview mode but the agreement printed a blank page when sent to the printer.

When the problem occurred today. I made many many changes to the agreement trying to get it to print correctly. What eventually resolved the problem was removing the generation of the account statement.  Once I removed it, the agreement started printing perfectly again.

The big question is why did the generation of the statement. It is simply a DoCmd.OpenReport "Statement", acPreview

The user really want all document to generate together but until I know why this occurred and how to resolve it I can't do that.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

744 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

17 Experts available now in Live!

Get 1:1 Help Now