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