RE: [MS_AccessPros] Format subreports

We can't see your report design so we need you to tell us if the Can Shrink is causing the gap.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: drtolson@verizon.net
Date: Fri, 9 Sep 2011 10:40:12 -0400
Subject: RE: [MS_AccessPros] Format subreports

Thank you Duane, yes both reports are set to Can Grow and Can Shrink.

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Friday, September 09, 2011 9:25 AM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Format subreports

Are the subreports set to can shrink? It sounds like an upper subreport is
shrinking and the lower subreport not moving up.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: drtolson@verizon.net
Date: Fri, 9 Sep 2011 09:34:40 +0000
Subject: [MS_AccessPros] Format subreports

Great Day! I have a report that has two subreports in it. In design view,
the subreports are stacked and I placed them about 1/4 inch apart; however,
when the report runs, if the subreport on the top has more than three rows
that are displayed, then the subreport on the bottom is displayed like it is
in design view; meaning that it is about 1/4 inch from the top subreport.
However, if less than three rows are displayed in the top subreport, then
the bottom subreport is displayed about an inch or more below.

What can I do to have the bottom subreport display 1/4 inch below the top
one in all situations?

Thanks in advance for your assistance.

r/David

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/