I asked a very similar question, but wasn't able to get a solution with v2010 - I have a page header that gives a nice look to the detail data in my report, but on the last page, the header prints, even though there is no accompanying data - I want that last page to ONLY show the report footer - I've attached a sample copy - any help would be greatly appreciated !

Does it make any difference if you have more/fewer records/details?

bakersburg9 & Jeff,

PMFJI.

Maybe try moving your customer information to the Customer Header
rather than using the Page Header.
Set the Page Header Visible to No.

HTH

I could eliminate some to make it work

take a look at my revision.

I think you attached the wrong .accdb - it's the same - cust header still shows up on the last page

Try the attached.

I moved your Customer data to the Customer Header as I had suggested earlier.

HTH

Im sorry I accidentally deleted one important variable. Here it is again.

I've seen your work Ms. Cynthia.

This post has been edited by arnelgp: Mar 15 2012, 10:50 AM

Cynthia, Thanks for your input, but that removed the header from the intermediary pages - there are pages with no header - all I wanted was no customer heading on the last page with the report footer, because it was confusing - you'd see this specific customer's name, yet no records for that customer

Sorry, I misunderstood.

Looks like arnelgp has what you need.

arnel,
I'm sorry - I'm not following what you want IN, what you want out - you have code that you've commented out - two lines - did you intend that ? I tried commenting them out - doesn't deliver the desired result - I've tried uncommenting them, and still - doesn't deliver the desired result, sorry...

mybe the comments confused you, here I cleaned it.

what else did you do besides the code ? I copied the code, and it didn't work overall - the specific thing I wanted, the cust header not printing on the last page worked, so that's good, but now on my version the headers don't print on every page.