Report Footer at bottom of page

[Guest]

How do I make the Report Footer appear at the bottom of the page? I can't use
the page footer because, if the report runs to several pages, I will have
multiple occurances of these controls.

Basically, I need four labels to be at the bottom of the last page.

Ideas?

Thanks,

Dave

 

[Guest]

You can put the lables in the page footer, and on the on print event of the
page footer write the code

Me.Lable1.Visible = ([Page] = [Pages])
Me.Lable2.Visible = ([Page] = [Pages])
Me.Lable3.Visible = ([Page] = [Pages])
Me.Lable4.Visible = ([Page] = [Pages])

 

[Guest]

Are [Page] and [Pages] internal to Access or are they calculated controls?

Thanks,

Dave

You can put the lables in the page footer, and on the on print event of the
page footer write the code

Me.Lable1.Visible = ([Page] = [Pages])
Me.Lable2.Visible = ([Page] = [Pages])
Me.Lable3.Visible = ([Page] = [Pages])
Me.Lable4.Visible = ([Page] = [Pages])

--
Good Luck
BS"D

How do I make the Report Footer appear at the bottom of the page? I can't use
the page footer because, if the report runs to several pages, I will have
multiple occurances of these controls.

Basically, I need four labels to be at the bottom of the last page.

Ideas?

Thanks,

Dave

 

[fredg]

How do I make the Report Footer appear at the bottom of the page? I can't use
the page footer because, if the report runs to several pages, I will have
multiple occurances of these controls.

Basically, I need four labels to be at the bottom of the last page.

Ideas?

Thanks,

Dave

Make your report as you normally would with the Page Footer and Report
Footer.

Make sure there is a control set to = [Page] & " of " & [Pages] in the
Page Footer.

Then for each control you wish to display on the final page footer,
place an unbound control where it should display.
Set each of these controls Visible properties to No.
(Do not disturb the controls you want to normally display at the
bottom of each page.

Next code the Report' Page Footer Format event:
If [Page] = [Pages] Then
[PageFooterControlName1] = [ReportFooterControlName1]
[PageFooterControlName1].Visible = True
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.
End If

If you have other controls in the page footer that you do not wish to
display on the final page, set them to Not Visible in the Page Footer
event.

You must leave enough Page Footer Height to print these controls.
I see no reason you can't stack these controls on top of your regular
page footer controls and turn Visible properties on and off as
required.

Next code the Report Footer's Format event:
Cancel = True

Then code the Report Header Format event:

[PageFooterControlName1].Visible = False
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.


The Report Footer information should display at the bottom of the
report where the Page footer normally does.

 

[Guest]

The Page returns the current page number, and the Pages return the number of
pages that are in the report, that are internal functions.
So, in the last page they will be equal, and then it will make the lable
visible.

--
Good Luck
BS"D

Are [Page] and [Pages] internal to Access or are they calculated controls?

Thanks,

Dave

You can put the lables in the page footer, and on the on print event of the
page footer write the code

Me.Lable1.Visible = ([Page] = [Pages])
Me.Lable2.Visible = ([Page] = [Pages])
Me.Lable3.Visible = ([Page] = [Pages])
Me.Lable4.Visible = ([Page] = [Pages])

--
Good Luck
BS"D

How do I make the Report Footer appear at the bottom of the page? I can't use
the page footer because, if the report runs to several pages, I will have
multiple occurances of these controls.

Basically, I need four labels to be at the bottom of the last page.

Ideas?

Thanks,

Dave