This sample db demonstrates placement of report footer on top of page footer. It
caters for variable heights of report headers / footers (CanGrow property = Yes). If
there is going to be any potential blank space between report footer and the page
footer, it is moved above the report footer so that the bottom of report footer sits on
top of the page footer.
The desired objective is achieved by inserting an outermost dummy group footer
whose height is manipulated at run time so as to serve as dynamic blank spacer
block.
Two stage opening of report is undertaken because dynamic grown heights of
report sections are available only in print event. On the other hand, adjustment of
section heights is permitted only in format event. Hence the need for extra cycle of
report opening.
Stage A - First cycle of opening the report, stores dynamic values of Report
Footer bottom and Page Footer top in unbound text boxes on form F_SwitchBoard
Stage B - Re-opens the report, duly adjusting the height of outermost dummy
group footer, so as to force the report footer bottom to move close to page footer
top.
Note - In the sample db, 4 lines of text in report header as well as footer are
inserted programmatically in unbound text boxes, just to cover grown height
features of sections concerned.
5 - Version: Access 2K/XP/2K3/2K7 (Access 2000 File Format) Download Access 2K/XP/2K3/2K7: http://www.rogersaccesslibrary.com/forum/uploads/37/Report_ReportFooterOnTopOfPageFooter.zip -
|