asked on

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.

Sincerely,

David
Independent-Auto-Report-Footer-P.png

Jeffrey Coachman

Post a image of the report in design view...

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

Helen Feddema

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 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.

yddadsjd95

ASKER

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.
Independent-Auto-Image-of-Report.png

ASKER CERTIFIED SOLUTION

Richard Daneke

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

yddadsjd95

ASKER

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.

Sincerely,

David