Conditional Page Break

  • Thread starter Thread starter gr
  • Start date Start date
G

gr

I have a report with several subreports. for some of these
subreports after or before them I need to put a Page
break.
but if the subreport is empty I don't want the page break
to happen.
I put the page break in the main report, putting it in the
subreport never does the page break.

How can add a conditional behavior to the page break?
or any other suggestions?
thx
 
gr,

I did not test this idea, so treat it as "air code". On the On Format
event of the main report's section, put something like this...

Me.NameOfPageBreakControl.Visible = Me.NameOfSubreport.Report.HasData

- Steve Schapel, Microsoft Access MVP
 
yes! worked great!
-----Original Message-----
gr,

I did not test this idea, so treat it as "air code". On the On Format
event of the main report's section, put something like this...

Me.NameOfPageBreakControl.Visible = Me.NameOfSubreport.Report.HasData

- Steve Schapel, Microsoft Access MVP




.
Click to expand...
 
Back
Top