Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reporting Query 1

Status
Not open for further replies.

BuilderSpec

Programmer
Dec 24, 2003
383
GB
I have a requirement to put some text at the bottom of a report..but it only wants to appear at the bottom of the last page..

if i use page footer it is on every page which i don;t want and if i use report footer it's not at the bottom of the page which i don;t want...

any one got any ideas how i can have some text at the bottom of a particular page ( will always be the last on in report ) ?

Regards

BuilderSpec
 
Hi
Maybe include a text box in the page footer and a little code:
Code:
Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
If Page = Pages Then
   Me.[[i]TextBoxName[/i]].Visible = True
Else
   Me.[[i]TextBoxName[/i]].Visible = False
End If
End Sub
 
thanks..

i had got the text box idea i just couldn;t figure how i would know i am on the last page...

simpe really page = pages ..thanks a lot !


BuilderSpec
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top