hide label

[nitr0]

Hi,

i have one report with several subreports, subreports have can shrink property set on Yes..so when their query is null, subreport does not show, but their label does so i want something like this but i dont know syntax

i tried like dis

in VBA - report:
Private Sub Report_load()
Me.Label12.Visible = Not IsNull(now should be there Query which is empty or not but it is another as report source)

End Sub

of cource label12 have default visibility false

thx for help in advance

 

[PeterF]

You can use the HasData property of the report, as this returns True or False you can set the visability like:

Me.Label12.Visible = [YourSubRapporControlName].[Report].[HasData]

 

[nitr0]

thank you for this..but i found out that i was wrong that it will be such easy..because :

my main report which have several subreports - are grouped by ID, so one query store many info, so never will be 0 = label is always visible,

i think i need something like this:

Hide label if there no record for current ID in query..i dont know if it is even possible