print section at bottom of page

How do you format a group footer to always print at the bottom of the page in
Access 2003?

Why? To try to force an electronic document to match some old printed form
that provided extra lines on the page because the author did not actually
know how many items needed to be printed?

There are some ugly ways to do it, such as adding a bunch of unbound text
boxes into the Page Footer section to simulate the layout of the group
footer, and then assigning the values in the Print event of the group
footer, and clearing them again in the Page Header event, and putting up
with the unusable space on the bottom of every page.

Or setting the report's NextRecord property to False, MoveLayout to True,
and PrintSection to False when the Detail section gets to the last record so
that it keeps repeating that record's space until the report's Top property
gets far enough down the page to print the group footer.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Myron" wrote in message
...
How do you format a group footer to always print at the bottom of the page
in
Access 2003?

Allen, This has nothing to do with a pre-printed form. I am writing a report
and would like the same information printed at the bottom of the page at the
end of each group. Crystal report writer does this function.

"Allen Browne" wrote:

Why? To try to force an electronic document to match some old printed form
that provided extra lines on the page because the author did not actually
know how many items needed to be printed?

There are some ugly ways to do it, such as adding a bunch of unbound text
boxes into the Page Footer section to simulate the layout of the group
footer, and then assigning the values in the Print event of the group
footer, and clearing them again in the Page Header event, and putting up
with the unusable space on the bottom of every page.

Or setting the report's NextRecord property to False, MoveLayout to True,
and PrintSection to False when the Detail section gets to the last record so
that it keeps repeating that record's space until the report's Top property
gets far enough down the page to print the group footer.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Myron" wrote in message
...
How do you format a group footer to always print at the bottom of the page
in
Access 2003?