Set report control visible=false based on value in detailed records (for each record)

[Colin@Toyota]

I think I pretty much described my issue in the title... I have a report, and in the details section, if a field is = 0, I would like to set a label's visible property to true, and if the field's value is <>0, set the label's visible property to false. As always, any help is appreciated.

Happy holidays everyone!!

 

[HiTechCoach]

In the detail section's On Format event try something like:

Me.YourLabelName.Visible =  (Me.YourControl = 0)

You will need to substitute the actual control names to match the ones on your report.

Hope this helps ....

 

[Colin@Toyota]

Thanks for your help guys, I appreciate it. I ended up using your method, Pat, as I also had 4 other labels that needed to go .visible = false if the first one goes .visible = true

Cheers!