label to be visible if subform has no data

  • Thread starter Thread starter Andy Staunton via AccessMonster.com
  • Start date Start date
A

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
*****************************************
 
Andy said:
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.
Click to expand...


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