Stop a subreport from printing

  • Thread starter Thread starter robert demo via AccessMonster.com
  • Start date Start date
R

robert demo via AccessMonster.com

I have a report with a subreport. Before displaying this report from my
application, I allow the user to select what they would like to display on
the report. Printing of the subreport is optional.

I'm using the following code:

If PrintProfileProposalFlag = True Then
Me.SubReport1.Visible = True
Else
Me.SubReport1.Visible = False
End If


The subreport currently prints on the last page of the report. When the
flag is set to false, the subreport is not displayed, but a blank page
still prints.

How do I suppress the printing of this last page when the flag is set to
false?

Thanks.
 
Set the "can shrink" property of the sub report , and the section here the
sub report is in, to true.
 
Back
Top