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.
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.