Label box visible if subform value is null

[Chimp8471]

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

i have a report called "ModelFinalReport"

which has a subform called "ModelFinal"

And in that subform a textbox called "VAT"

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

how should this be written please.

Cheers

Andy

 

[Rich]

Report or Form?

 

[Chimp8471]

sorry "Report"

 

[Rich]

Use the HasData method, examples have been posted here

 

[Chimp8471]

i have looked at this all morning and am getting nowhere fast, any further tips please..

as i was not very clear in my first description here is how i believe it should have read...

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