Report resizing andrew.menendez[ at ]raymondjames.com 29.09.2006 19:51:28 I'm trying to fit more rows of data per page on a report, however resizing it manually in design view does not seem to help me reach my goal. The text keeps getting smaller and smaller, and there's more than enough room to allow for extra rows, yet there's no change. Is there an alternative way of doing this? I'm comparing my report with another similar report that seems like it has bigger text, yet can fit more rows of data on it.

Re: Report resizing fredg <fgutkind[ at ]example.invalid> 29.09.2006 20:25:42 On 29 Sep 2006 12:51:28 -0700, andrew.menendez[ at ]raymondjames.com wrote: [Quoted Text] > I'm trying to fit more rows of data per page on a report, however > resizing it manually in design view does not seem to help me reach my > goal. The text keeps getting smaller and smaller, and there's more than > enough room to allow for extra rows, yet there's no change. > > Is there an alternative way of doing this? I'm comparing my report with > another similar report that seems like it has bigger text, yet can fit > more rows of data on it. Did you set the report section's CanGrow property to Yes? -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail

Re: Report resizing Marshall Barton <marshbarton[ at ]wowway.com> 29.09.2006 21:11:19 andrew.menendez[ at ]raymondjames.com wrote: [Quoted Text] >I'm trying to fit more rows of data per page on a report, however >resizing it manually in design view does not seem to help me reach my >goal. The text keeps getting smaller and smaller, and there's more than >enough room to allow for extra rows, yet there's no change. > >Is there an alternative way of doing this? I'm comparing my report with >another similar report that seems like it has bigger text, yet can fit >more rows of data on it. You also need to make the control'd Height property. If all the controls are text boxes, then you can set the text boxes and their section's CanShrink property to Yes. Also make sure there is little or no space above, below or between (vertically) the controls. It is important when moving controls to make sure that they do not overlap top to bottom so double check their Top and Height properties. OTOH, you can make all the controls shorter than required to contain the text and set their CanGrow property instead. -- Marsh MVP [MS Access]