Jim Dettman
jimdettman at verizon.net
Wed Jan 4 08:10:49 CST 2012
David, In addition to what's been suggested, you also might want to take a look at: ACC2000: How to Print a Group Footer at a Specific Location http://support.microsoft.com/kb/208979 Couple different methods there. Some work better then others for different types of reports. Also, something in regards to reports which just came up on EE is drawing vertical/horizontal lines on a page (the above article is what made me think of this). A lot of us have run into this; were trying to duplicate a pre-printed form or want blank detail lines even though we don't have enough records to fill the page. The person asking the question actually came up with the solution and it's the first time I've ever seen it used. What he did was to use a Group *header* to format the entire page before anything else had been rendered on it. I didn't realize that you could even address the entire page outside of the OnPage event. Then he used MoveLayout = False in the header to keep the same point on the page and continued on from there. You can read it here (no signup or login required): http://rdsrc.us/ygyZCD Pretty slick! Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson Sent: Tuesday, January 03, 2012 10:19 PM To: accessd at databaseadvisors.com Subject: [AccessD] Report Footer on Last Page of Group I have a report that creates invoices. When the report is run it includes invoices for several businesses. At the bottom of each business invoice is about 1/3 of a page of "footer" text. Most of the invoices fit onto one page. My problem is when the invoices spill over onto more than 1 page. If I put the "footer" text into the footer section for the business then they appear at the end of the businesses invoice but may not be at the bottom of the last page. If I put the "footer" text into the page footer section then it appears at the bottom of each page but also on the pages where there might be more than one page for a business. Because the "footer" text takes up so much space I do not just want to hide the fields if it is not on the last page for a business because this will leave a large amount of blank space on the pages before the last one. How can I use the space that would be taken up by the footer if I put it into the page footer section, or alternatively, how can I put it at the bottom of the last page of each invoice if I put it in the Business footer section? Regards David Emerson Dalyn Software Ltd Wellington, New Zealand -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com