Report Section Height Issues

[Martin]

Hi,

I have an Access 97 report that mimics an official UK Covernment
Customs document, with Page Headers and Footers presenting static data
for each page (logos etc). The report is made up (typically) of
several lines of detail data, with a few summary lines at the foot of
these. I am (nearly) achieving the right "look and feel" by presenting
the line items in the Report Detail section and the summary lines in
the Report Footer BUT...

....the "real thing" has vertical lines running down the body of the
document. I have managed to programatically replicate these by using
me.Line in the respective onFormat events of the Detail and Report
Footer, EXCEPT for a problem with the last page.

If there are only one or two detail items on the last page, then the
Report Footer follows immediately on (as I want), but there is then a
big space between the bottom of the Report Footer and the final page
footer, completely ruining the effect that I am seeking.

What I want to be able to do is grow the Report Footer so that it
fills this "white space". If I can do this, then hopefully I can
"draw" lines within the Report Footer down to the final Page Footer
and the net result will look like the real document - rather than the
unusable mess that it currently is !

Any help/guidance would be appreciated.

TIA

Martin

[Stephen Lebans]

Re: Report Section Height Issues

Have a look at the older non class based solutions here:

http://www.lebans.com/PrintLines.htm

If I remember correctly you would use the Line method in the Page event
for the last page.
--

HTH
Stephen Lebans

http://www.lebans.com

Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Martin" <martin.kingsto n@dana.com> wrote in message
news:af97ad9.04 02040912.11cef3 25@posting.goog le.com...[color=blue]
> Hi,
>
> I have an Access 97 report that mimics an official UK Covernment
> Customs document, with Page Headers and Footers presenting static data
> for each page (logos etc). The report is made up (typically) of
> several lines of detail data, with a few summary lines at the foot of
> these. I am (nearly) achieving the right "look and feel" by presenting
> the line items in the Report Detail section and the summary lines in
> the Report Footer BUT...
>
> ...the "real thing" has vertical lines running down the body of the
> document. I have managed to programatically replicate these by using
> me.Line in the respective onFormat events of the Detail and Report
> Footer, EXCEPT for a problem with the last page.
>
> If there are only one or two detail items on the last page, then the
> Report Footer follows immediately on (as I want), but there is then a
> big space between the bottom of the Report Footer and the final page
> footer, completely ruining the effect that I am seeking.
>
> What I want to be able to do is grow the Report Footer so that it
> fills this "white space". If I can do this, then hopefully I can
> "draw" lines within the Report Footer down to the final Page Footer
> and the net result will look like the real document - rather than the
> unusable mess that it currently is !
>
> Any help/guidance would be appreciated.
>
> TIA
>
> Martin[/color]

[Martin]

Re: Report Section Height Issues

Stephen,

Thanks, it worked just fine (great website, too !).

For the benefit of anybody else who may be following this thread, what
I did was include the following code(simplified to show just one
vertical line being drawn) in the On Page event of the REPORT:-

With Me
.ScaleMode = 1
.ForeColor = 0 ' 0=Black,
' Measurement is in twips
' 1 * 1440 represents 1 inch; 1 * 567 represents 1 cm
Me.Line (2.778 * 567, .Section(acPage Header).Height)- _
(2.778 * 567, .ScaleHeight - (.Section(acPag eFooter).Height ))
End with

This draws a line on EVERY page 2.778 cm in from the left-hand margin,
stretching from the PageHeader to the PageFooter - exactly what I was
trying to achieve. The beauty of this code is that I then did not have
to worry about drawing lines in either the Detail or Report Footer
sections.

Thanks once again.

Martin
_________
"Stephen Lebans" <ForEmailGotoMy .WebSite.-WWWdotlebansdot com@linvalid.co m> wrote in message news:<gWbUb.879 92$IF6.2236351@ ursa-nb00s0.nbnet.nb .ca>...[color=blue]
> Have a look at the older non class based solutions here:
> http://www.lebans.com/PrintLines.htm
>
> If I remember correctly you would use the Line method in the Page event
> for the last page.
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "Martin" <martin.kingsto n@dana.com> wrote in message
> news:af97ad9.04 02040912.11cef3 25@posting.goog le.com...[color=green]
> > Hi,
> >
> > I have an Access 97 report that mimics an official UK Covernment
> > Customs document, with Page Headers and Footers presenting static data
> > for each page (logos etc). The report is made up (typically) of
> > several lines of detail data, with a few summary lines at the foot of
> > these. I am (nearly) achieving the right "look and feel" by presenting
> > the line items in the Report Detail section and the summary lines in
> > the Report Footer BUT...
> >
> > ...the "real thing" has vertical lines running down the body of the
> > document. I have managed to programatically replicate these by using
> > me.Line in the respective onFormat events of the Detail and Report
> > Footer, EXCEPT for a problem with the last page.
> >
> > If there are only one or two detail items on the last page, then the
> > Report Footer follows immediately on (as I want), but there is then a
> > big space between the bottom of the Report Footer and the final page
> > footer, completely ruining the effect that I am seeking.
> >
> > What I want to be able to do is grow the Report Footer so that it
> > fills this "white space". If I can do this, then hopefully I can
> > "draw" lines within the Report Footer down to the final Page Footer
> > and the net result will look like the real document - rather than the
> > unusable mess that it currently is !
> >
> > Any help/guidance would be appreciated.
> >
> > TIA
> >
> > Martin[/color][/color]