Report Header/Footer 1

[jtfrier]

I have a report that has a group in it to repeat and filter out duplicats I need to have a signature line on the last page of the report but the report footer seams to be linked to the group and when I Place the signature line in the report footer it places the text right under the grouped infroemation. not at the bottom of the last page . I cant put it in the page footer because I only want it to show up on the last page of the report.

 

[AlexMidd]

This is a problem. You could increase the size of the footer to force the item further wdown the page, but this might produce unpredicatble results if the length of the report changes.

Have fun! )

Alex Middleton

 

[jtfrier]

That wont work because I have info in the page footer any other sugestions?

 

[AlexMidd]

If you put a text box in the place that you require, in the Page Footer, then set the ControlSource to the following it should work (Replace "Your Text" with the text you want to appear):

=IIf([Pages]=[Page],"Your Text","")

Have fun! )

Alex Middleton

 

[jtfrier]

ok thanks I should be able to use the code to get it to do what i need. Thank you.