Footers

  • Thread starter Thread starter Chris Gardner
  • Start date Start date
C

Chris Gardner

What help can someone give me on footers.

I would like to keep a group footer from printing by
itself on the page following the detail. Using keep
together does not give me the results I want. I want to
print at least one detail line before the group footer
line.

Thanks
 
Chris, that cannot be achieved without code, because Access formats each
section separately, and your requirement is, "Don't print the last detail
section on the page if the group footer won't fit as well."

To do that, you will need to examine the Top property of the report in the
Format event of the Detail section, and if you are too far down the page to
fit both this detail section and the group footer in the remaining height,
then do a page break now. This will only be practical if:
- you are comfortable with VBA code;
- the Detail section and group footer are fixed height (i.e. you don't have
CanGrow/CanShrink causing large changes to the height of the sections).

Add a page break control to the Detail Section.
In the Format event of the Detail section, examine Me.Top.
The Top property is measured in twips. 1440 twips = 1 inch.
Calculate how much height is left on the page, from the page height.
Remember to allow for the bottom margin.
If there is not enough height left, set the Visible property of the Page
Break control to Yes.

The Page Break control does have a Visible property, even though it is not
enumerated in the list of properties in the VBA editor.
 
Back
Top