Blank page if sub report has no data

  • Thread starter Thread starter deb
  • Start date Start date
D

deb

I have a report with 3 sub reports.
When one of the sub reports has no data it creates a blank page.
I have the margins formatted corectly. It only creates a blank if the sub
report has no data.

Is there a way to fix this?
 
Make sure that the Subforms and the section which contains the subform has
the Can Grow, Can Shrink property set to Yes. Ensure that there are no
controls (eg lines) or labels holding the section open.
If you have page breaks in place, then use the On Format event of section to
make them invisible.

If Me.MySubFormControl.Report.HasData = 0 Then
Me.MyPageBreakControl.Visible = false
Else
Me.MyPageBreakControl.Visible = True
End If

Evi
 
Back
Top