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 - ReportBorders.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: ReportBorders.mdb
    Posted: 07 Jul 2008 at 10:36pm

Updated On 18-Dec-2011
Explanatory Notes

    This sample database demonstrates a simplified approach for creation of Inner & Outer borders for Access reports. Insertion of blank rows after last record, is also demonstrated.

    Following styles are covered:
    (a) Report With Outer Borders
    (b) Report With Border Grid - Spreadsheet Style (Vertical and horizontal inner borders along with outer border)
    (c) Blank Rows After Last Record - Fixed Height of Report Header / Footer
    (d) Blank Rows After Last Record - Dynamic Height (Can Grow = Yes) of Report Header / Footer

Important - For style (b) above:
(a) KeepTogether property of detail section should be set to Yes, so as to prevent the possibility of missing top detail line at start of a new page (caused by spill over of detail section across two pages).
    (b) It has to be ensured that report header section has a discreet height (more than zero). Otherwise, report header print event won't fire.

    Style (d) above, involves two stage opening of report and makes use of Stephan Leban's function fTurnPage().

Version:  Access 2000 File Format

Reference:  Nothing Extra 

Download File >>: 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.