Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - Report_ReportFooterOnTopOfPageFooter.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)


 Post Reply Post Reply
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: Report_ReportFooterOnTopOfPageFooter.mdb
    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 
    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 
    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: uploads/37/


Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.