Report widows

  • Thread starter Thread starter Bill Brosius via AccessMonster.com
  • Start date Start date
B

Bill Brosius via AccessMonster.com

Using MS Access 2003:

Looking for a way to keep a group footer with "Last Detail" when generating
a report. I see there is an option for headers, but not for footers. Any
ideas?
 
Examine the Top property of the report in the Format event of the Detail
section.

The Top property shows how far down the report page you are. Access gives
you the measurement in twips, where 1440 twips = 1 inch. If you are too far
down the page to fit the detail section plus the group footer, you can force
the Detail section onto the next page.

To do that, add a PageBreak control to the top of the Detail section (it's
in the Toolbox). Then in Detail_Format, toggle its Visible property. (It
does have a Visible property, even though it doesn't show in the
Intellisense.)
 
Back
Top