[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • Last Modified:

How can I repositioin 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
0
yddadsjd95
Asked:
yddadsjd95
  • 2
1 Solution
 
OnALearningCurveCommented:
Hi David,

In the design view of the main report try setting the hight of the first sub-report to quite small (say 1/4 of an inch) and then place the second report the correct distance away from it.  Then make sure the "Can Grow" property of the first sub-report is set to yes.  With this in place the sub-report should always grow in size but I think Access will preserve the gap between the end of this report in the design view and the start of the second one.

Hope this makes sense.


Mark.

0
 
yddadsjd95Author Commented:
OnALearningCurve, What a way to start my morning! It works and the form looks much better now when it is printed with just a few records in it.

Thanks a million and have a great day!

Sincerely,

David
0
 
OnALearningCurveCommented:
No problem,

glad I could help.

Thanks for the points :)

Mark.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now