Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Problem with Report Footer

Posted on 2011-10-26
Medium Priority
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
ID: 37033986
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

by:Helen Feddema
ID: 37034122
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 19

Expert Comment

by:Richard Daneke
ID: 37034210
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.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 37034324
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 19

Accepted Solution

Richard Daneke earned 2000 total points
ID: 37034504
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

ID: 37034537
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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Implementing simple internal controls in the Microsoft Access application.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

581 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