Conditional Visibility of Label in Report

[nathan sanders]

Hi,

I have a Discount label & text box on my Invoice report.

Problem is, I would rather that they didn't appear for on invoices for
customers who do not get a discount.

Is there a way of controlling the visibility of these based on the value of
the text box?

Cheers
Nathan

 

[Guest]

In the OnFormat Property of the section where the fields are, put the code

Me.discountLabelName.visible = nz(me.Discount,0)
Me.discountTextName.visible = nz(me.Discount,0)

 

[nathan sanders]

Thank you Ofer,

That worked exactly as required.

Nathan