I have placed three unlinked subreports in the Report Header of an unbound main report and I want the records in each subreport to be listed in two equal-height columns (down, then across). Setting CanGrow to "Yes" in the subreports will cause the records to appear in a page-long column on the left (in Print Preview) before starting to populate the right column. But when I manually set the subreport control (i.e., the subreport's container on the main report) to a short enough height and set CanGrow to "No", the records in the subreport (or as many of them as will fit) will populate both columns.
So, in the ReportHeader_Format event of the main report, I calculate the height needed for each subreport. Then I try to set each subreport control to its desired height with this:
Not only does this not work, but Access stops responding until I end the task. The reference to the control in my code works to GET the height, but not when I try to SET the height. What am I doing wrong?
So, in the ReportHeader_Format event of the main report, I calculate the height needed for each subreport. Then I try to set each subreport control to its desired height with this:
Code:
Me.Section(acHeader).Controls(strSubreport).Height = intControlHt