[AccessD] Sub Report not going into Two Columns

David Emerson newsgrps at dalyn.co.nz
Mon Mar 6 12:12:54 CST 2006


Thanks AD.  I managed to get around it by positioning the text boxes 
in two columns and setting their height to what was required to show 
all the text.  CanGrow was turned off because the text was different 
lengths which meant some boxes in the opposite column would be pushed 
down and leave gaps.

David

At 7/03/2006, you wrote:
>David,
>
>     It transpires that your report does not deal with a set of 
> records. Instead you are having text boxes (with CanGrow set to 
> "Yes"), having large text content.
>
>     This situation is not amenable to multicolumn layout. 
> (Granularity for spreading the display across columns is a record).
>
>Best wishes,
>A.D.Tejpal
>---------------
>
>   ----- Original Message -----
>   From: David Emerson
>   To: Access Developers discussion and problem solving
>   Sent: Wednesday, March 01, 2006 04:14
>   Subject: Re: [AccessD] Sub Report not going into Two Columns
>
>
>   The report is a column of text boxes with the control source being
>   set to a string (eg ="This is a sample string").  Because of the
>   varying size of the strings, and different printers format report
>   text slightly differently, I have set the text boxes to a height of
>   1, and set the Can Grow property to Yes.
>
>   When the report is viewed itself the text boxes snake down the first
>   column of the first page, then the second column of the first page,
>   then to the first column of the second page.  This is what I want.
>
>   However, when I use the report as a sub report to another report
>   (along with a number of other sub reports) it stays at one column.
>
>   The main report page settings (Column Tab) is set to one column
>   (because other reports are full width), column size width 19.5.
>
>   The sub report page settings (Column tab) is set to 2 columns, row
>   spacing 0, column spacing 0.3, column size width 9, column layout
>   down then across. Changing to across then down has the effect of the
>   sub report not snaking over two columns when run on its own, nor in
>   the main report.
>
>   David.
>
>   At 28/02/2006, you wrote:
>   >David,
>   >
>   >     It has been stated in your post that there are no records. Yet
>   > it is mentioned that when run as independent report, the two
>   > columns  display nicely, filling up two pages. Could you please
>   > clarify this apparent contradiction?
>   >
>   >     Various values as actually existing on Columns tab of page set
>   > up dialog box of the report may also please be furnished. If you
>   > are getting two column output in independent report mode, it can be
>   > ensured that you get similar display in subreport mode.
>   >
>   >     With Across, then Down (A&D) layout, it is straightforward.
>   > However, in this case, there can be awkward white spaces if the
>   > contents of records across columns do not always measure up to same
>   > number of lines. Down, then Across (D&A) layout overcomes such
>   > drawback but routine adoption of this layout in a subreport puts
>   > everything into one column (even though the original report is
>   > designed for two columns). There is a solution for that too.
>   >
>   >Best wishes,
>   >A.D.Tejpal
>   >---------------
>   >
>   >   ----- Original Message -----
>   >   From: David Emerson
>   >   To: Access Developers discussion and problem solving
>   >   Sent: Tuesday, February 28, 2006 03:33
>   >   Subject: Re: [AccessD] Sub Report not going into Two Columns
>   >
>   >
>   >   Thanks for the reply William.  I tried all that with no joy.  I might
>   >   just have to go to fixed formatting.
>   >
>   >   David
>   >
>   >   At 27/02/2006, you wrote:
>   >   >...best guess is that the width of your design subreport area on
>   > the report is narrower than the width of the two columns in the
>   > subreport when the "can grow" is fully expanded at runtime ...try
>   > decreasing the font size of the columns to verify this is the
>   > problem ...or disable the "can grow" ...hth.
>   >   >
>   >   >William
>   >   >
>   >   >----- Original Message -----
>   >   >From: "David Emerson" <newsgrps at dalyn.co.nz>
>   >   >To: <accessd at databaseadvisors.com>; <ACCESS-L at PEACH.EASE.LSOFT.COM>
>   >   >Sent: Monday, February 27, 2006 12:07 AM
>   >   >Subject: [AccessD] Sub Report not going into Two Columns>
>   >   >
>   >   > > Cross Posted Access D, Access L
>   >   > >
>   >   > > Access XP.
>   >   > >
>   >   > > I have a report which is a long column of text boxes with the text
>   >   > > entered into the control source. Because different printers format
>   >   > > reports slightly differently I have made the boxes shorter than the
>   >   > > text warrants and have set the can grow property on for 
> all the text
>   >   > > boxes.  There are no records associated with this report.
>   >   > >
>   >   > > I have set the Page Setup .. Number of columns to 2 and when
>   > I view the report the text boxes flow over two columns.  The full
>   > report is two pages long.
>   >   > >
>   >   > > However, when I use the report as a subreport for another
>   > main report then the text boxes remain in one column.  I have
>   > checked help and it suggests changing the column order to across
>   > then down.  I have tried this but it doesn't make any difference (I
>   > guess because there are no records).
>   >   > >
>   >   > > Apart from physically placing the text boxes in two columns, does
>   >   > > anyone know how I can get them to flow properly?
>   >   > >
>   >   > > Regards
>   >   > >
>   >   > > David Emerson
>   >   > > Dalyn Software Ltd
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com




More information about the AccessD mailing list