Hide Labels (1 Viewer)

[mark curtis]

I have a report which uses many subforms and on the sub forms I have labels such as "description". My problem is that when the report runs and the subforms load some of the records return no data which I expect but the labels are still visible. Is there anyway that I can hide the labels if the control has no data and if so where such I place any code.
Thanks

I used the below but still can't get it to work.

Ian Fornatian

In the OnOpen event of the specific subform put this code:
If Isnull(Me![MyTestField] then
Me![MyTestFieldsLabel].visible = false
End if

 

[Richie]

Do you want to hide the label on the subform or report?

 

[mark curtis]

I want to hide the label on the subreport when it loads into the main report.

Thanks