Need variable-sized box at end of page before page footer

  • Thread starter Thread starter Deb
  • Start date Start date
D

Deb

I've got an Access report that prints one, two, or three groups on a
page (using keep together). When the page breaks, there is usually
some blank space at the bottom of the page before the page footer. I
would like to draw a box to fill that space. Is there a way to do
this?

First I think I need a way to anticipate a page break. When I get to
the end of a group, I don't know whether or not a page break will
occur (the following group may be short or long). If I know that a
page break is about to occur, then I need a way to use the line method
to draw a box from the current position to right above the page
footer. (Would I use group footer for this?)However, there may not be
room on the page for any box at all, in which case I need to suppress
any action.

Can anyone help?

Many thanks,
Deb
 
Since Marsh, Larry, FredG, Stephen, and others haven't responded I don't
think there is a known solution. I would re-think the requirements.
 
I produced a solution for a similiar situation. Should not be much to
adapt it to the OP particular issue.
http://www.lebans.com/lastgroupheaderfooter.htm
LastGroupHeaderFooter.zip is a database containing functions to allow
you to track the positions of the GroupHeader and Footer sections in
order to place text directly in the last Group Header or Group Footer
section on each page. Supports multiple columns.

Version 2 Sept 29/2000

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
I figured as soon as I suggested it couldn't be done, Stephen would come
along with a solution...
 
Back
Top