How do I not print a page in a report

[SFC]

I have a report that the last page is in the footer section (a large footer that can take up a whole page). Is there a way that the footer section does not print based on a variable in a table? I would like it if a specific field in the table is "False" then the footer will not print, thus not printing the last page in my report.

[June7]

Maybe. Try code in the Format event of the footer section. I assume you mean the report footer.

[SFC]

Hi June7,
Thanks for the reply, I do mean the report footer. I tried a macro with no success and I'm just leaning code, do you know some code to get me started?

[June7]

I don't use macros, just VBA.

Is this report displaying multiple records or filtered to a single record? Never done anything like this but try:

Me.ReportFooter.Visible = Me.fieldname

If that doesn't work and you want to provide db, will analyse for other solution. Follow instructions at bottom of my post.