Forced New Page (1 Viewer)

P

plengeb

New member

Local time

Today, 09:38

Joined

Sep 28, 2011

Messages

9

• Sep 28, 2011

• #1

Stopping The Last Report Page From Printing

Is there a way to prevent the last page of a report from printing (If me.page = me.pages, then do not print the page)? Thank you.

 

Last edited: Sep 28, 2011

V

vbaInet

AWF VIP

Local time

Today, 14:38

Joined

Jan 22, 2010

Messages

26,374

• Sep 28, 2011

• #2

What displays on the last page? Do you mean printing to screen or to paper?

 

P

plengeb

New member

Local time

Today, 09:38

Joined

Sep 28, 2011

Messages

9

• Sep 29, 2011

• #3

The basic header and footer informationi displays on the last page with no data. The report prints to screen first, then you can print to paper as desired.

There is a section where I need to force a new page after it is finished. After the last record is printed, that section forces a final, blank page, and I want to prevent that last blank page from printing. Thank you.

 

V

vbaInet

AWF VIP

Local time

Today, 14:38

Joined

Jan 22, 2010

Messages

26,374

• Oct 1, 2011

• #4

Do you see a blank page when you print to screen or when you send it to the printer? Or both?

 

P

plengeb

New member

Local time

Today, 09:38

Joined

Sep 28, 2011

Messages

9

• Oct 12, 2011

• #5

The blank page appears both when you print to screen and to the printer.