Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

isnull [Label].visible=false not working-- need loop?

Status
Not open for further replies.

factotum

Technical User
May 29, 2002
48
US
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
Code:
null
to Many. I have the Labels set up to not be visible when
Code:
null
using:

Code:
 If not isnull([Field]) then
      me![FieldLabel].Visible = true
 Else
      me![FieldLabel].Visible = false
 Endif
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top