this must be easy! I want to put some stuff at the end of the rpt

W

wilbur88

sometimes my report is 1 page. sometimes there is enough data to fill 2 or 3
or 4 pages. I have some stuff (a couple labels and some text) that I want to
appear always at the very bottom of the last page. But I don't want it to
appear at the bottom of any of the other pages. How can I do this? It must
be easy!
 
K

Ken Snell [MVP]

Use the Report Footer section for those textboxes... this section prints
only at the bottom of the last page.
 
W

wilbur88

Hello Ken,
Well, I may be crazy, but I just made a report from scratch. I put 3
records in the table underlying the report, and I added a report footer. I'm
afraid the report footer comes right after the 3rd record! It is definitely
not at the bottom of the page. And this is the easy case, there is only 1
page in my report!
 
K

Ken Snell [MVP]

Sorry... I slightly misread your question. No, you're correct in what you
see.. the report footer prints after the last data record for the report.
There is no built-in way to make the report footer go to the bottom. You
must do it via some "tricky" programming that has to check the "height" of
the last page, determine the "height" of your footer, subtract the two, and
calculate how much "white space" to be put into the footer, which probably
would be done by changing the height of the textboxes in the footer and then
adding blank lines to the beginning of the text in those textboxes so that
the data print at the bottom.

However, Stephen Lebans may have something already worked out for this...
see his site www.lebans.com.

--

Ken Snell
<MS ACCESS MVP>
 
Top