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!

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

Report footer problem

Status
Not open for further replies.
jfrye

jfrye

Technical User
Oct 29, 2001
2
US
I have a report that has 12 months of data being displayed in months along with a monthly footer, which of course shows up 12 times in the report. I want to suppress the footer for all but the last two months based on criteria set on one variable. Is there a way to do this?
 
Sort by date Sort by votes
Try using the OnFormat event of the PageFooter section. For example:
Code: 
Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer)
  Me.Section("PageFooter").Visible = (SomeCriteria = True)
End Sub
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bennie47250
  • Locked
  • Question
Report Crashes
Replies
2
Views
352
kray4660
kray4660
Eddi Rae
  • Locked
  • Question
Change Page header when subreport is in the report footer. 1
Replies
11
Views
905
dhookom
dhookom
LondonJohn
  • Locked
  • Question
Problem using Access 2003 and 2007 for the same database
Replies
4
Views
577
LondonJohn
LondonJohn
Moss100
  • Locked
  • Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
361
dhookom
dhookom
Jaime_78
  • Locked
  • Question
DoCmd.OpenReport Hangs when user wants to select location of report to save to
Replies
2
Views
405
Jaime_78
Jaime_78

Part and Inventory Search

Sponsor

Back
Top