sub report

I have several sub reports in a report. Right now when there are a lot of
records in a sub report it will run over the top of another sub report that
is placed below it. How can I keep the spacing the same even when the report
grows?

Fipp wrote:

I have several sub reports in a report. Right now when there are a lot of
records in a sub report it will run over the top of another sub report that
is placed below it. How can I keep the spacing the same even when the report
grows?


That typically happens when the top control's bottom
overlaps the top of the control below it.

--
Marsh
MVP [MS Access]

On Mon, 23 Jul 2007 19:13:42 -0500, Marshall Barton
wrote:

Fipp wrote:

I have several sub reports in a report. Right now when there are a lot of
records in a sub report it will run over the top of another sub report that
is placed below it. How can I keep the spacing the same even when the report
grows?


That typically happens when the top control's bottom
overlaps the top of the control below it.

I just posted this in another thread, but it may help here too:

Here's a trick to make sure that adjacent controls are touching
but not overlapping: Select two or more adjacent controls. Click
Format, Horizontal Spacing (or Vertical Spacing), Decrease.

Access will not decrease spacing to less than zero. It will actually
*increase* the spacing to exactly zero, making the controls touch each
other perfectly without overlapping.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com