Problem with Report Footer

Posted on 2011-10-26
Last Modified: 2013-11-28
Great Day, I have been printing a report with two subreports during about a one month test period and the report has been printing with no problem. Today, I did some extensive work on it to modify a few of the features. I'm not sure what I did, but the Report footer in one of the subreports is printing about 5 times the size it should. I have looked at every possible thing that I can think of that I may have altered, but nothing seems to have changed since I created the report. I have enclosed an image of what it looks like. You will note that the bottom subreport that displays parts purchased has a properly formatted report footer, while the Description of Repair has a report footer that should be the same size as the parts used report footer, but it appears to about 5 times its size.

Can anyone  give me some advice on what I may have done to cause this change?

Thanks in advance for your help.


Question by:yddadsjd95
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    Post a image of the report in design view...

    ...Perhaps you have the Can Shrink property of that object set to: No
    LVL 31

    Expert Comment

    If the too-tall subreport is always the same height, regardless of the number of line items, then it probably is the CanShrink property that is the problem (try setting it to Yes, and see if that fixes the problem.)
    LVL 18

    Expert Comment

    by:Richard Daneke
    Yes, check the Can Grow/Can Shrink property.

    Also, check to see if you inadvertently extended the height of the footer section.   You can drag the bottom of the footer grid over your text.  Access will ensure that all controls will print and it will expand the height of the footer to cover the controls.   When manipulating the desing, it is easy to accidentally extend the height and/or the width of the report section.

    Author Comment

    I tried everyone's suggestions and I am still not getting the desired results. Here is the applicable part of the report in design view.
    LVL 18

    Accepted Solution

    Set the can shrink to Yes for the subreport property - not just the footer


    Reduct the size of the window for the subreport and use the Can Grow to yes for the subreport properties

    Author Closing Comment

    Thank you DoDahD, I still do not know why the results changed with no apparent alteration to the form, but your suggestion gave me the results I was looking for; the one where I set the Can Shrink property to Yes on the subform.

    Have a great rest of the day and an even finer day tomorrow.



    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    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…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    734 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

    20 Experts available now in Live!

    Get 1:1 Help Now