Label box visible if subform value is null

[Chimp]

Can i have a label appear if a value in my subform is null.

i have a report called "ModelFinalReport"

which has a subreport called "ModelFinal"

And in that subreport a textbox called "VAT"

i also have a label on my main Report that i want to appear if the text box
"VAT" in subreport "ModelFinal" returns a null value. but be invisible if
"VAT" returns a true value.

how should this be written please.

Cheers

Andy

 

[Marshall Barton]

Can i have a label appear if a value in my subform is null.

i have a report called "ModelFinalReport"

which has a subreport called "ModelFinal"

And in that subreport a textbox called "VAT"

i also have a label on my main Report that i want to appear if the text box
"VAT" in subreport "ModelFinal" returns a null value. but be invisible if
"VAT" returns a true value.

As long as they're both in the same section, you can use the
section's Format event procedure:

Me.thelabel.Visible = IsNull(Me.ModelFinal.Report.VAT)