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

  • Thread starter Thread starter Wonder Puppy
  • Start date Start date
W

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
 
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.
 
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."
 
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.
 
Back
Top