Hello. I'm relatively new to Access (I have some very limited experience with Visual Basic .NET). I'm designing a report which has a few requirements that I cannot seem to get Access 2010 to fulfill.
The report I am going to generate will always have two pages and may or may not have a third page.
This link explains how I want the pages to appear:
The reason for the unusual formatting requirement is that the first two pages will be printed on both sides of the same paper. If the report extends to page 3, that will be a separate piece of paper that will need a company logo and contact information.
I've tried hiding the header for page 2 by making access check what page it is printing and making the headersection invisible if it is page 2. But that leaves an ugly whitespace that I don't want. And apparently, the page header/footer don't have the "canshrink" property (only report header/footer do). The problem with adding the logo and contact info to report header/footer is that I don't know how to replicate the header for page 3 and footer for page 1 (since access will try to print it only at the end of the whole report).
Any help will be very much appreciated.
Need help with report formatting
The report I am going to generate will always have two pages and may or may not have a third page.
This link explains how I want the pages to appear:
Code:
http://ift.tt/1EamE9o
I've tried hiding the header for page 2 by making access check what page it is printing and making the headersection invisible if it is page 2. But that leaves an ugly whitespace that I don't want. And apparently, the page header/footer don't have the "canshrink" property (only report header/footer do). The problem with adding the logo and contact info to report header/footer is that I don't know how to replicate the header for page 3 and footer for page 1 (since access will try to print it only at the end of the whole report).
Any help will be very much appreciated.
0 commentaires:
Enregistrer un commentaire