Report Footer, multi-column rpt

[FPS, Romney]

Hi,

I have a multi-column report which prints correctly, except for the report
footer. In the report footer I have a line which extends across the width of
the page, plus a subreport which spans about 3/4 of the page.

*If* the last column of data in the detail section carries over to the last
page of the report, then the line in the report footer prints out across the
full width of the report. If, however, the last column of data ends on the
preceding page, then the line in the report footer extends only the width of
a single column. The subreport in the report footer extends across the page
correctly, regardless of whether the last column of data ends on the
preceding page or carries over to the last page.

The report contains a Client header, detail section, and Client footer. I
have code in the Client footer Format event which hides/unhides a couple of
fields in the Client footer, but removing this code has no effect on the
problem.

Any suggestions?
Thanks,
Mark

 

[FPS, Romney]

The problem may be isolated to Access 97, which is where I designed the
report. Probably at the time of design, there were enough records to carry
over to the last page of the report so the problem was not immediately
apparent. I checked on one of our Access 2000/2002 computers and the
full-width of the footer is visible in print preview even though the
data-columns end on the preceding page. We have the same default printer,
although there is a different version for Win 98 versus XP.

Anyone have any further insight into this?

Mark

 

[Jeff Boyce]

Mark

I've not run across references to this kind of mis-behavior before. Have
you had any luck searching on-line?

I have noticed that Access sometimes gets subtly corrupted. Nothing appears
wrong but something doesn't work correctly. Have you tried rebuilding this
report from scratch, rather than working with a copy of the old definition?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[FPS, Romney]

Thanks, Jeff
I haven't searched very far on-line and I only tried a copy of the report
.... not rebuilding it entirely. I'll try both.
Mark

 

[Steve]

Try adding another subreport to the report footer and make the subreport the
full width of your report footer. Put your line in that subreport and make
the line the full width of the subreport. Since the subreport you already
have works correctly, the new subreport ought to work too.

Steve
(e-mail address removed)

 

[FPS, Romney]

Thanks, Steve
Yes, that would work. Actually, the line was just an example. The main
object that I didn't want shortened was a label which describes a text field
included in the footer. Your suggestion would work just as well for the
label as for the line.
It would seem to be a good work-around, so thanks.
Mark