Conditional Visibility of Label in Report

N

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
 
O

Ofer

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)
 
Top