Report Footer

[Guest]

I have a subreport in the Report Footer of my report. This is displayed
based on a control on a form. The problem is when a subreport does need to
be visible sometimes there is an extra blank page in report.

This happens because of report footer. I can not reduce the height of a
report footer because it has the subreport in it. Does anyone have any
suggestions? Thanks for the help.

 

[Allen Browne]

Why not set the subreport control very short (say, 0.1" tall), and set its
Can Grow property to Yes? Access will give it more vertical space when it
needs it.

 

[Larry Linson]

Why not set the subreport control very
short (say, 0.1" tall), and set its Can Grow
property to Yes? Access will give it more
vertical space when it needs it.

And, also, be sure the CanGrow property of the Report Footer is set to Yes,
so it can grow to contain the Subreport Control when it grows.

Larry Linson
Microsoft Access MVP