Skip report header on print

[vivasuzi]

Hi guys.

I have a report header that is a page by itself. This page is really just instructions on how to view the report.

Is it possible to skip this page when printing? I saw the "on print" even but I've never used this. I would like the user to be able to print the report without the first page showing up. (It is always the first page b/c it is the report header) I only wanna do this b/c I don't want to make my users have to choose which pages to print everytime. And I don't want this page to be printed and wasting space everytime.

Thanx.

*Suzanne*

http://www14.brinkster.com/vivasuzi

 

[vivasuzi]

OTHER OPTION -

I wanna change my request Instead of not printing the report header that has instructions, can I move these instructions into a pop-up that will come up when the report is opened??

That way the user can read the popup, hit ok and not worry about printing certian pages. I need to have the instructions everytime they open the report bc I want to make sure they know what they are looking at, but I don't want it on the actual page of the report bc these are sent to other businesses.

Thanx a lot.

*Suzanne*

http://www14.brinkster.com/vivasuzi

 

[dhookom]

You can add code to open a form in dialog mode when the report opens. If you instructions aren't to long, you can set the On Open event property to:
=MsgBox("Make sure you have yellow paper in the printer.",vbOkOnly+vbCritical, "Print Alert")

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[vivasuzi]

Ok getting there.

How do you put a new line in a msg box? I tried /n but that didn't work.

I want it to look like:

Put yellow paper in the printer.
Choose Manual Feed when printing.

*Suzanne*

http://www14.brinkster.com/vivasuzi

 

[dhookom]

=MsgBox("Put yellow paper in the printer." & Chr(13) & Chr(10) & "Choose Manual Feed when printing.")

Duane
MS Access MVP
Find out how to get great answers faq219-2884.