Print Page | Close Window

Report_ReportFooterOnTopOfPageFooter.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=53
Printed Date: 11 Dec 2017 at 12:54am


Topic: Report_ReportFooterOnTopOfPageFooter.mdb
Posted By: A.D. Tejpal
Subject: Report_ReportFooterOnTopOfPageFooter.mdb
Date Posted: 07 Jul 2008 at 10:51pm
   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 -




Print Page | Close Window