Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 459
  • Last Modified:

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

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
mlcktmguy
Asked:
mlcktmguy
  • 2
1 Solution
 
mlcktmguyAuthor Commented:
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
 
PatHartmanCommented:
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
 
mlcktmguyAuthor Commented:
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now