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

B

babs

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]
 
D

Duane Hookom

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

Matthias Klaey

babs said:
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??
Click to expand...

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
 
B

babs

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
 
B

babs

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

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


babs said:
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]
Click to expand...
Click to expand...
 
B

babs

Any ideas!!!

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

thanks,
barb
 
Top