Suppress page break if subreport has no data

G

Guest

I have a report with 9 subreports and a page break control after each
subreport. When a subreport does not contain any data, I get a blank page. Is
there a way to suppress the page break control when a subreport has no data?
 
J

John Spencer

In the format event of the main report section containing the sub report.

Me.SomePageBreakControl = Not(Me.SomeSubReport.HasData)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subreport with no records 8
Access How to prevent subReport from breaking across pages? 1
Page breaks across subreports 1
Suppress Blank Subreports 2
Suppress hard page-break if no data? 4
Page break before subreport if subreport has data 1
suppress report detail 1
SynNeed to account for null values in subreports 2

Top