David Emerson
newsgrps at dalyn.co.nz
Mon Feb 27 16:03:04 CST 2006
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 > > 999 Moonshine Rd, RD 1 > > Judgeford, Porirua 6006 > > Phone (04) 235-6782 > > Fax (04) 235-6783 > > Mob (027) 280-9348 > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com