Debbie
delam at zyterra.com
Wed Aug 25 16:04:10 CDT 2010
Different issue. Footer fields are in the report footer so they are filling from the end of the detail down. That works fine, there is no extra gap. The details have more space in between each detail record than there is between calculated rows in the footer. The detail rows are shorter than the controls of the footer rows. The footer rows have a tiny gap between rows also. Despite this, the footer rows appear closer vertically than the detail section rows. By everything I know, they should appear closer together, not further apart now. Debbie Sent from my iPhone On Aug 25, 2010, at 3:43 PM, "Jim Hewson" <jm.hwsn at gmail.com> wrote: > 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? > > Jim > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie > Sent: Wednesday, August 25, 2010 3:12 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Access 2007 question > > The detail section and all controls in it can shrink. Everything > else is > fixed. Since the detail is too tall, can grow did not seem prudent. > The > footer is spaced correctly, so no option to change. Do you think I > should > try some other combination? > > Debbie > > Sent from my iPhone > > On Aug 25, 2010, at 2:33 PM, "Steve Schapel" > <steve at datamanagementsolutions.biz >> wrote: > >> Debbie, >> >> Have you tried playing with the Can Grow and Can Shrink properties of >> the sections and the controls? >> >> Regards >> Steve >> >> >> -------------------------------------------------- >> From: "Debbie" <delam at zyterra.com> >> Sent: Thursday, August 26, 2010 7:17 AM >> To: "Access Developers discussion and problem solving" >> <accessd at databaseadvisors.com> >> Subject: [AccessD] Access 2007 question >> >>> I am putting together a report in access 2007. The footer has >>> several >>> rows of calculated fields and the detail has the fields calculated >>> from. >>> >>> Visually, I am trying to make all of the rows space the same in the >>> detail and footer so they all look like a continuous section. My >>> problem is that the detail section is visually further apart than >>> the >>> manual rows in the footer. I have reduced the height if the detail >>> section to .1354" and the footer rows are .1667" top to top, and the >>> details still look farther apart. >>> >>> I really need the vertical real estate, so increasing the spacing in >>> the footer is not an option. Any ideas where thus extra space is >>> coming from? And most importantly how to get rid of it? >>> >>> Debbie >>> >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >