sub report

[Guest]

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?

 

[Marshall Barton]

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.

 

[Armen Stein]

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