Solved How stop MS Access from printing blank page at the end of a report

[nector]

Hi

Is there a way or VBA code to stop access from printing extra page which is blank at the end of the report. For example, page 1 has only two lines of data, but it will also print page 2 which is completely blank which is a waist of paper.

We have been intervening manually by going into print manager by selecting page 1 to 1 or if there are two pages then it will be page 1 to 2, but this is very cumbersome.

Any idea here.

 

[Minty]

It will be something to do with the report section settings (header, footer, detail, etc) , possibly force a new section/page after ...
You will need to fiddle with all the settings to find it I'm afraid.

You can tell in print preview how many pages it will be using, so try layout view and see if that helps identify it?

 

[arnelgp]

in Layout view of the report, check if some Controls cross pass the Right page margin, and move them or adjust the width.

//Edit
too late, Minty hit it hard on the head!
so Mr Minty has the right solution, I hope Mr.Gasman/Kitayama has no complains.

 

[nector]

The issue on the subreport now its working okay

 

[arnelgp]

The issue on the subreport now its working okay

what is the issue with the subreport? is it too wide?

 

[nector]

what is the issue with the sub report? is it too wide?

There were some hidden controls in the footer sub report taking a wider space, after shrinking them to zero all was sorted out, thanks to minty he opened up my thinking

 

[KitaYama]

I hope Mr.Gasman/Kitayama has no complains.

I'm sorry if I posted something that caused a misunderstanding. I meant the OP had the answer sooner, not who solved the problem. I simply thought she had missed #2 post and wanted her to know it. I also understand that MajP explained how, but you simply showed the exact code. And I'm one of those who am more comfortable to see the code, rather than been explained the method. So I can not blame her for missing the post.

My comment by no means meant you didn't solve the problem. I apologize if the way I said it was wrong or took the wrong words to cause this confusion. It's mostly because of the difference in our culture, and it's not the first time I say something that offends someone. I try to be more careful in picking the words and explain what I mean.
I can delete my post, but deleting it doesn't take the harm away.
I'm really sorry.