A.D. - Thank you, yes, I would like some help with this. I tried using your example ReportTwoColBalanced.mdb, but I could not get it to work in the sub report. Dawn Crosier Application Specialist "Education Lasts a Lifetime" This message was posted to a newsgroup. Please post replies and questions to the group so that others can learn as well. ________________________________
From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of A.D.Tejpal Sent: Monday, January 16, 2006 12:19 PM To: AccessDevelopers@yahoogroups.com Cc: ADT Subject: Re: [AccessDevelopers] Multi Column Report Dawn, In order to force balanced display of both columns on a two column subreport located in detail section while adhering to "Down & then Across" layout for the columns, following measures are necessary. (a) CanGrow property of the control (on main report) serving as container for the subreport should be set to "No". (b) The height of this subreport control as well as the detail section should be manipulated dynamically at run time, taking into account the number of rows contained in the subreport. (c) If the number of records in subreport is large and likely to spill beyond one page, these should be handled in suitable virtual packets so that vertical height of subreport control needed for displaying the contents of any given packet does not exceed the space available on one page. If you happen to need further assistance in this regard, I could put together a sample db demonstrating the approach outlined above. Best wishes, A.D.Tejpal -------------- Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
