if not visible can you make text box -take up NO Space on Report

[Guest]

Need Report Footer to be at BOTTOM of last page

I add the code below to handle that the Footer on the last page is at the
bottom but-
All other pages prior show a big Blank space at the bottom. would like the
text boxes to shrink??? if possible so there wouldn't be that blank space on
every page.

any ideas??


Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As
Integer)
[sig1].Visible = Me.[Page] = [Pages]
[sig11].Visible = Me.[Page] = [Pages]
[autouser].Visible = Me.[Page] = [Pages]
[sig2].Visible = Me.[Page] = [Pages]
[sig22].Visible = Me.[Page] = [Pages]
[verb1].Visible = Me.[Page] = [Pages]
[verb2].Visible = Me.[Page] = [Pages]
[date].Visible = Me.[Page] = [Pages]

 

[Guest]

I am not aware of any way to dynamically shrink the size of a page header or
footer section.

 

[Matthias Klaey]

Need Report Footer to be at BOTTOM of last page

I add the code below to handle that the Footer on the last page is at the
bottom but-
All other pages prior show a big Blank space at the bottom. would like the
text boxes to shrink??? if possible so there wouldn't be that blank space on
every page.

any ideas??

As Duane said, unfortunately Access reports do not have this feature.
However, it can be done in code, but this is quite involved.

Are the detail lines in your report of fixed height?
Is the report footer of fixed height?

I might be able to give you an outline of the code based on the
answers to these questions.

Greetings, Matthias Kläy

 

[Guest]

The detail section obviously depends on the number of records and yes the
Report footer is a Fixed Height. Will the code work for this?????

Thanks,
Barb

 

[Guest]

Is there now way to make the Report Footer be at the BOTTOM of the last page
without doing it the page footer way-and having a large blank at the bottom
of all pages but last.

thanks,
barb

I am not aware of any way to dynamically shrink the size of a page header or
footer section.
--
Duane Hookom
Microsoft Access MVP

Need Report Footer to be at BOTTOM of last page

I add the code below to handle that the Footer on the last page is at the
bottom but-
All other pages prior show a big Blank space at the bottom. would like the
text boxes to shrink??? if possible so there wouldn't be that blank space on
every page.

any ideas??


Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As
Integer)
[sig1].Visible = Me.[Page] = [Pages]
[sig11].Visible = Me.[Page] = [Pages]
[autouser].Visible = Me.[Page] = [Pages]
[sig2].Visible = Me.[Page] = [Pages]
[sig22].Visible = Me.[Page] = [Pages]
[verb1].Visible = Me.[Page] = [Pages]
[verb2].Visible = Me.[Page] = [Pages]
[date].Visible = Me.[Page] = [Pages]

 

[Guest]

Any ideas!!!

Need to do today if possible- would love to try the vb code.

thanks,
barb