Solved

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

Posted on 2014-01-28
3
442 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 1

Author Comment

by:mlcktmguy
ID: 39815873
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 36

Accepted Solution

by:
PatHartman earned 500 total points
ID: 39816176
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
ID: 39816575
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
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.
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…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

740 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