Access Reports with SubReports Blank Pages

[pockets337]

Hello,



I am designing a report that has 7 separate subreports that will populate based on whether there is information in its category or not. If the subreport has no information relevant to it, it will appear blank. However, I need each subreport to be on a different page so I put page breaks between all of them. The problem I am having is that each report for a customer only requires 1-4 subreports, so the other subreports that have no information are still displaying blank, but they populate a blank page when I print.

Does anyone know how I can solve this issue? It is not an issue with the size of the report/subreport being on multiple pages, my margins have been adjusted properly. I am capable of some visual basic programming if that is a solution.

I found a code that looks like:

If Me.[subreport].Report.HasData = False Then
Me.PageBreak.Visible = False
End If

But I'm not sure where I would put the code in. I'm not sure if it would work or not but any input that you have would be helpful.

Thanks,

Ryan

[rpeare]

I think you can set the 'visible' property of the page break character (even though you can't see it in the properties window) to 'NO' if you do a record count on the query driving the subreport and it's zero.