Prevent form from printing

[Randy]

I have a command button on my form that will print a report. Occasionally
someone will accidently press the print button at the tool bar, thus
printing endless forms instead of an indivual report. I need to figure out
a way that will prevent this. I only want the report printed using the
command button...Thanks ...Randy

 

[fredg]

I have a command button on my form that will print a report. Occasionally
someone will accidently press the print button at the tool bar, thus
printing endless forms instead of an indivual report. I need to figure out
a way that will prevent this. I only want the report printed using the
command button...Thanks ...Randy

Click on the toolbar. Select Customize.
Drag that print button off the tool bar onto the dialog box.
The above will affect all Forms.

If you ever change your mind, highlight the toolbar in the Customize
dialog box and click Reset.

Better yet, make your your own customized toolbar, omitting the Print
button.
Name the toolbar. Then in the forms ToolBar property (it's on the
Other tab) write it's name.
Only this form will be affected.

 

[Randy]

How do I create a custom tool bar. That sounds like what I want...Thanks

 

[fredg]

How do I create a custom tool bar. That sounds like what I want...Thanks

Access Help files:
Toolbar + Create a toolbar + Create a Custom toolbar

 

[TC]

if currentobjecttype <> acreport then
msgbox "no way, Jose!"
endif

HTH,
TC

 

[111]

I'm having a similar problem - I want to remove completely the FIle Print
function in access - i have some forms with data that I don't want the user to
be able to print out - is there a way to remove this feature from access and
only have the reports i've set up printable?

tks