hide labels in report for zero fields

[fpoulenc]

Is there any way to hide a label based on the value of its field? I am doing
an employee report and don't want to show fields and labels when they are not
applicable. I can use conditional formatting to hide the zero value field,
but it will not hide the associated label. Each employee gets their page in
the report, so I want some pages to have the field and label, and others,
where there is no data, not to see it.

 

[Duane Hookom]

Try change the label to a text box with a control source like:
=IIf([YourField]=0,Null,"Your Label")

 

[fpoulenc]

Thanks Duane! I had tried other suggestions on the forum, but yours is the
only one that worked.

Try change the label to a text box with a control source like:
=IIf([YourField]=0,Null,"Your Label")

--
Duane Hookom
MS Access MVP

Is there any way to hide a label based on the value of its field? I am
doing
an employee report and don't want to show fields and labels when they are
not
applicable. I can use conditional formatting to hide the zero value
field,
but it will not hide the associated label. Each employee gets their page
in
the report, so I want some pages to have the field and label, and others,
where there is no data, not to see it.