Report_ReportFooterOnTopOfPageFooter.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
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)
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |