Problem with Report Footer

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.


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
Post a image of the report in design view...

...Perhaps you have the Can Shrink property of that object set to: No
Helen FeddemaCommented:
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.)
Richard DanekeTrainerCommented:
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.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

yddadsjd95Author Commented:
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.
Richard DanekeTrainerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
yddadsjd95Author Commented:
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.


It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.