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)

Report_ReportFooterOnTopOfPageFooter.mdb

 Post Reply Post Reply
Author
Message
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 
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: uploads/37/Report_ReportFooterOnTopOfPageFooter.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down