Setting subreport to visible (Access 2K/SR1)

Topic

New Reply

How do you tell Visual Basic to set a subreport to Visible if the data is not Null? Example below works great for labels that are part of the main report:

Dim blnResolved as Boolean
blnResolved = Not IsNull(DateResolved)
DateResolvedLabel.Visible=blnResolved

HOWEVER, I’d like for it to also hide labels for the subreports that are null. How do I do that?

TIA

Reply | Quote

Replies

Check out the HasData property of the subreport in on-line help. That’s what it is intended for, to see if there is data in the subreport so you can display or hide it as appropriate.

Reply | Quote

Exactly what I needed. Thanks.

Reply | Quote