Label box visible if subform value is null

  • Thread starter Thread starter Chimp
  • Start date Start date
C

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

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)
 
Back
Top