I have a report that has the labels in a group heading but the containers in the details section. This way, I'm not repeating the Labels with every record.
The records returned in can vary from
to Many. I have the Labels set up to not be visible when
using:
However, if the first returned record is null, but the second one isn't, the labels disappear. Not really the effect I was after.
Any one know how to cycle through the returned records to ensure that they are all null before setting the visibility to false. Thanks.
=D
The records returned in can vary from
Code:
null
Code:
null
Code:
If not isnull([Field]) then
me![FieldLabel].Visible = true
Else
me![FieldLabel].Visible = false
Endif
Any one know how to cycle through the returned records to ensure that they are all null before setting the visibility to false. Thanks.
=D