Microsoft Access - Hide objects on specific pages
Asked By Jason on 04-Sep-12 06:16 PM
I was wondering how you would hide an object in the footer of a report based on a which page the report is on. The problem is the report will vary in length so I'm not sure how to reference the detail section of the report. I've tried putting a text box with =[page] and reference this text box in the on format footer code but it doesn't work. Any ideas?
Pat Hartman replied to Jason on 09-Sep-12 10:58 PM
If it is something that you want to only appear at the end of the report, use the ReportFooter rather than the PageFooter. Otherwise, you'll need to give us more information. What causes the footer to be populated for starters?