Remove last report page

[IceGirlAnne]

Hi!

I made a report from a query that I did, but the last page of the report shows a page header & footer even though there is no data to be shown. Is there a way to get rid of that last blank page that has the page header & footer from the report.

Thanks so much for your help!!

 

[fernin8r]

When you're in design view, under the section labeled Header and the section labeled Footer, click and drag any white space you can see, till there is none left.

Another question is. are you sure it's the header/footer. sometimes when a report is to wide a second blank page shows up. Make sure you click and drag the right side of the report to shrink its width as much as possible.

hth

 

[IceGirlAnne]

I tried..

Hi,

I just tried and it didn't seem to work. It's as if the last page thinks that there is data there to be shown but there is no more data to show, so it's just a big blank space there with the page header and footer.

 

[fernin8r]

I'd have to see your report. Can you post it?

 

[fernin8r]

I've gotta go. sorry i couldn't help. i'm sure someone else can figure it out. have a great weekend.

 

[IceGirlAnne]

thanks!

Hi!

I tried it again and I think I got it to work!! Thanks for all of your help!!!