Preventing a form from printing

[gbradley]

In Access97 can you prevent a form from printing?
Disable Ctrl-P
Thank-you for any feedback

 

[Stubby Holder]

Hi,

To disable ctrl + P, make sure the Form's KeyPreview set to Yes, and, using the code builder, paste this in the Form's On Key Down event:

If Shift And acCtrlMask Then
    If KeyCode = vbKeyP Then
        KeyCode = 0
    End If
End If

HTH,stubby

 

[gbradley]

Thanks that worked great.
Now I just have to prevent the immediate print button on the toolbar

 

[Stubby Holder]

Hi,

If it is suitable for your database, why not create your own toolbar that only has what you want on it? If so, you could then select your new toolbar in the 'all' or 'other' properties of your form.

You would also have to uncheck the 'allow full menus' & 'allow built-in toolbars' in Tools/Startup (you will have to shift-open the database to get the full menus for designing afterwards, though).

HTH, stubby

 

[gbradley]

Thank-You I think that is what I'd like to do.
Here's the thing....
The guys are supposed to hit a command button on the Form.
This Command button opens up a Report in Print Preview.
Then they hit the Print button on the toolbar

I don't know how to put a command button work in print preview.
I'll keep working on it.

Wait I think I get it....
I guess I can create another Macro that prints the Report only.
I'll put a command button on my custom toolbar that runs this Macro.
Thanks for your help.