Steve Schapel
steve at datamanagementsolutions.biz
Wed Aug 25 15:54:38 CDT 2010
Jim, I had assumed Debbie was talking about the Report Footer, not the Page Footer. But in any case, the problem (as I understand it!) is that the Detail records are showing higher than desired, not the other way around. Regards Steve -------------------------------------------------- From: "Jim Hewson" <jm.hwsn at gmail.com> Sent: Thursday, August 26, 2010 8:43 AM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Access 2007 question > This is my understanding of the issue. > You have data in the footer of the report and then you have relevant data > in > the detail section of the report. > The footer fills up from the bottom up. That is if the footer's data > takes > up one inch it fills it up from the bottom margin up. One inch from the > margin of page. > The detail section is populated from the top down. If the detail's data > takes up 2 or 3 inches then it fills the page from the top of the detail > section down. > There will be a gap if the footer's top margin and detail's bottom margin > don't meet. > The page is a constant size so by filling in the data for both sections > there should be a gap. > > To fix the issue you'll need to move the footer's data fields to the > another > section. > You could create a group to show the detail data and then another section > to > show the data from the footer. > > Is that clear or did I just obfuscate the issue? >