We have a database that contains confidential information.
I have been requested to supress the printing of three feilds on a Access 97 Report but to have them visible on the PrintPreview - much the same as the property on Forms that allow a control to be visible on Screen only/Print only or always.
While I can hide the controls in the _Print event this is triggered when the report is previewed - I am supposeing that I need to be able to identify whether it is the Print Preview that is triggering the event or the command to print.
Does anyone have any ideas how to solve this one - or do I need to have two versions of the report - one with feilds and one without?
Thanks
I have been requested to supress the printing of three feilds on a Access 97 Report but to have them visible on the PrintPreview - much the same as the property on Forms that allow a control to be visible on Screen only/Print only or always.
While I can hide the controls in the _Print event this is triggered when the report is previewed - I am supposeing that I need to be able to identify whether it is the Print Preview that is triggering the event or the command to print.
Does anyone have any ideas how to solve this one - or do I need to have two versions of the report - one with feilds and one without?
Thanks