Hello...it's me again

Is there any way to force the report footer to the bottom of the last page of a report?

I am attaching a screen shot so it may give you a better idea as to what I am looking for.

Thanks
Larry

thanks for the screen shot, Larry, that helps. i got the following solution to work in A2003, you can see if it'll do the trick in A2010:

1. move the controls in your "print at the bottom of the page" group into the report's PageFooter section.

2. the screen shot shows that you have a "Page of Pages" control in the header (PageHeader section, i assume) already.

3. add the following code, as


i played around with it a bit. if the "page of pages" control is in a group header section, not the page header section, it might still work - if not you can try adding an unbound textbox control for "page of pages" to the page header section, or to the page footer section, textbox Visible set to False if you wish.

hth
tina

I think he already has the "page of pages" label on the header portion (based on the picture) and your code will do exactly work on it, Ms. Tina.

Thanks for the replies

It shows the page footer on all pages and I just need it on the last page.

Here is shot of the design view if that will help?

Thanks
Larry

your screen shot of Design view shows that you have the "page of pages" textbox control in both the ReportHeader section and the PageHeader section - that may be causing a problem.

all i can suggest is to play around with it, hon. move the code to various events in various sections to see if you can come up with a scenario that works. that's what i did, to get the solution i posted, because i've never tried to do this in a report before.

or maybe somebody who has more skill in manipulating reports (Marshall Barton, where are you??!) will post, and teach us both something. good luck with it!

tina

Thanks Tina

I have it working as long as there is 2 page...used the not with header...but if there should only be one page...I am up the creek without a paddle again... (IMG:style_emoticons/default/iconfused.gif)

Larry

Maybe this can help,


Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
If Me.Pages > 0 Then
Me.Section(4).Visible = (IIf(Me.Pages = 1, True, Me.Page = Me.Pages))
End If
End Sub

Thanks for the reply arnelgp

When I put your code in the Page Header...it put the Report Footer on the first page only...this could work if I can't get it on the last page...at least there is only one of them.

Thanks
Larry... (IMG:style_emoticons/default/notworthy.gif)

Hello Larry, you can try it on report with multiple pages and see if it does its purpose.

Thanks for the reply arnelgp

The report was 2 pages and most usually should be 2 pages.

It showed the footer on the first page and not the second page.

Thanks
Larry

what size is your paper size, and the size of your footer?
if we cant do it naturally, maybe we can force do to as it should.

Thanks for reply

It is letter size and the footer is 3.0104" inches.

Larry

Hello

You can view a post of the DataBase on another post titled Generate Invoice Numbers.

Thanks
Larry

okay, so we're part way there. when you posted the above reply, exactly what code did you use (copy/paste into your post, pls), and exactly where (what section, and what event)?

hth
tina

On the report properties Report Footer.


Thanks
Larry

P.S. : You can view a post of the DataBase on another post titled Generate Invoice Numbers.

This post has been edited by lkbree51: Apr 2 2012, 09:40 PM

Do you have the page footer set to not visible in the designer?

Thanks for the reply projecttoday

It is set as visible

Larry

P.S. : I uploaded it here because I can't figure out how to link to the other thread.

This post has been edited by lkbree51: Apr 2 2012, 11:01 PM

okay, so you're running the code from the ReportFooter section. that answers only part of my post. the rest is: exactly what code did you use (copy/paste into your post, pls), and exactly where (what section, and what event)?

hth
tina

Thanks Tina

I am not using any code...just Not with Rpt Hdr in the Property Sheet of the Report

Larry

So isn't the idea to make it visible when you hit the last page? So to start it has to be not visible?