[AccessD] Sub Report not going into Two Columns

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