hide control during printing

[aqif]

Hi

On my report there is a text box which just says:

This is a print preview version.

I just got a simple problem that I dont want to print that text box during printing. Can i do it with altering some property or code ? I have tried using OnPrint event but it didn't worked.

Cheers!
Aqif

 

[Adrianna]

Right click for Properties and change the DISPLAY WHEN property to SCREEN Only

This will prevent it from printing out, but will make it visible onthe screen!

Simple as that

 

[aqif]

cannot find it

Hi

I tried to find the Display When property but unfortunately there is no property like that. I am using Access 2000.

Cheers!
Aqif

 

[Graham T]

Adrianna

I think the Display When property is only applicable on a form.

If you wish to print a form, you can choose to display command buttons: Always, Print Only or Screen Only

I don't think you can do this in a report.

HTH

Graham

 

[Rich]

The only surefire way is to use custom menu bars for both preview and print, you have to set the visible property from your own button

 

[Adrianna]

I'm sorry...I usually reply to posts in the FORMs forum. I'm not sure how I ended up over here.

Anyway....


Can't you check:
IF the from is in OPenView for PrintPreview THEN
[txtbx].visible=true
ELSE
IF is PrintOut THEN
[txtbx].visible=false

Or...just keep the Print preview and Print Out Buttons Seperate and set the OnClick Event to

on the Preview Button
Me.txtbx.visible=true
DoCmd.OpenReport

on the PRINT Button
Me.txtbx.visible=fasle
DoCmd.PrintOut


Just an idea....good luck! Let us know if you find something better!