How can I repositioin a subreport

Posted on 2011-10-26
Last Modified: 2013-11-28
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.


Question by:yddadsjd95
    LVL 10

    Accepted Solution

    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.



    Author Closing Comment

    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!


    LVL 10

    Expert Comment

    No problem,

    glad I could help.

    Thanks for the points :)


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now