Page break before subreport if subreport has data

K

Kathy Webster

How can I create a page break before the subreport if and only if the
subreport has data?
Some records will have no data in the subreport, and I don't want an
unnecessary page break in those instances.
Thank you,
Kathy
 
D

Duane Hookom

Add a page break control and some code like:

Me.PgBrkName.Visible = Me.subrptName.Report.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
Suppress hard page-break if no data? 4
Error 2467 in report after splitting database 0
positioning a subreport 1
Subreport messing up spacing of report 4
Keep Together Subreports 2
SubReport On two pages 1
Report/Subreport Problems with Sorting/Grouping, Access 2003 2

Top