Breaking to new page within subreport (1 Viewer)

[DavidG3276]

I have a report which includes several subreports. There will be times when a subreport prints partially on one page and completes on the next. I don't always want to break to a new page with this subreport. However, I would want to break to a new page if the subreport cannot fully print on the current page. Any ideas?

 

[David R]

Place your subreports each into their own 'group' (via Sorting & Grouping), then you can use Properties > Detail > Keep Together: Yes to keep them from breaking across the page.

 

[DavidG3276]

Thank you so much! It seems a shame that you have to add a group to do this. I appreciate your help.

 

[David R]

Yeah, subreports themselves don't have a Keep Together property, so you have to trick Access.

http://social.msdn.microsoft.com/Fo...n-a-new-page-if-it-doesnt-fit-on-current-page