Visible Labels

[nayfeh]

I have a label that I want to make visible only is a field in my report has certain values in it. The field is named Printed in the underlying table (tbl_NOHeader). The label is called lblDuplicate. I would like this field to be visible on the report only is the values in Printed is > 0.

If you need any further info, please let me know.
Thanks in advance!
TN

 

[nealvenables]

Don't often introduce code into my reports, so this might need tweaking...

Private Sub Report_Activate()

lblDuplicate.visible = (txtPrinted > 0)

End Sub

 

[nayfeh]

I don't think this works.
I would like the Duplicate label to appear if the value in the field Printed is > 0.

Should this code go in the OnPrint event? I didn't know there was an event for Report_Active.

 

[nealvenables]

Have you tried it?

I lifted this from an app I put together several months ago, and the "Report_Activate" method seems to do the job of reformatting each printed page of the report it sits behind.

 

[nayfeh]

For some reason, the DUPLICATE label is always showing on the report. Should this label be visible when I set it initially up on the report?

If anyone can please help me with this problem, I'd appreciate it.

Thanks,
TN