David-
Set the Can Shrink property of the subform control to No.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of djsdaddy531
Sent: Thursday, October 27, 2011 4:39 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Can I reposition a subreport?
Great Day, I have a report that displays the data of two subreports. the report
has a Report Header; a Page Header, and the two subreports are in the detail
section. In design view, these reports are positioned about a 1/4 of an inch
apart, and they are both approximately the same size, give or take about 1/16 of
an inch. However, the subreport that is on top preserves that 1/4 inch based on
the amount of data that is displayed. If 4 or more records are displayed in the
top subform, then the 1/4 inch distance is preserved; however if fewer than 4
records are displayed, then this top subform shrinks and there is a large amount
of space between the top subform and the one on the bottom.
Is there anyway to alter the position of the bottom subform to maintain its 1/4
inch distance from the top subform when the top subform shrinks? Aesthetically,
the gap of white is not too pleasing.
Thanks in advance for your assistance.
Sincerely,
David
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar