label to be visible if subform has no data

[Andy Staunton via AccessMonster.com]

firstly, Hi,

this is my first post....

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 called"lblnodata" 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

*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=60549939535c4530ba59a000809315a3
*****************************************

 

[Marshall Barton]

firstly, Hi,

this is my first post....

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 called"lblnodata" 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.

Interesting!? I answered the same question from Chimp
earlier today. Am I doing you guy's homework?