[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?

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