By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 938 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.

Report Section Height Issues

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <ma*************@dana.com> wrote in message
news:af*************************@posting.google.co m...
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


Nov 12 '05 #2

P: n/a
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(acPageHeader).Height)- _
(2.778 * 567, .ScaleHeight - (.Section(acPageFooter).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" <Fo****************************************@linval id.com> wrote in message news:<gW*********************@ursa-nb00s0.nbnet.nb.ca>...
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" <ma*************@dana.com> wrote in message
news:af*************************@posting.google.co m...
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.