How do you set up a button, closing report, which does not print

[Wonder Puppy]

I am trying to place a button on the print preview which will close the
preview if desired but not appear on the printout if printed. I'm a newbie so
please excuse the simplicity of this request.

Thanks All

 

[BruceM]

It would help to know what you have tried so far, but in general the syntax
is:
DoCmd.OpenReport "YourReportName", acViewPreview

Substitute the actual name of the report for YourReportName. The
acViewPreview is what prevents immediate printing.

 

[Al Campagna]

Wonder Puppy,
Objects like buttons or combos, or lists, etc... have no events on a
report, and are not progammable.
A button object can be placed on a report, but it can't have any
function.
Use the File/Close or X to close the report, or create a custom menu
for your reports with just a Close and Print button, to prevent users from
accessing other normal report menu items.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Chuck]

On Thu, 22 May 2008 06:28:02 -0700, Wonder Puppy <Wonder

I am trying to place a button on the print preview which will close the
preview if desired but not appear on the printout if printed. I'm a newbie so
please excuse the simplicity of this request.

Thanks All

To close print Preview, press the Esc key.

Chuck

 

[BruceM]

I misunderstood the question. You could use a command on the menu bar or a
tool bar to close the report. You can't place a button directly on a
report, but you can customize toolbars and menu bars if you want to present
users with an assortment of options other than the default ones.