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 - SubReportTwoColBalanced.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: SubReportTwoColBalanced.mdb
    Posted: 06 Jul 2008 at 10:50pm
The sample db demonstrates balanced display of two columned subreport, 
despite adoption of "Down And Then Across" (D&A) layout.

Normally, "Across And Then Down" (A&D) layout is more convenient for getting 
balanced columns. However, in such an arrangement, there can be awkward blank 
spaces in one column if the contents of adjacent one overflow into multiple rows. 
This can be remedied by adopting D&A layout.

Direct adoption of D&A layout in a subreport does not work as the first column itself 
continues to expand when CanGrow property of the container control is set to 
"Yes". Remedy lies in setting CanGrow property of the subreport control to "No" 
and manipulating its height at run time. This is done by two stage opening. In stage 
1, subreport alone is opened and required heights are stored in an array. These 
values are then used for regular opening of main report in stage 2.

Download Access XP & 2K: 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.