Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    225

    Unanswered: Label box visible if subform value is null

    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

  2. #2
    Join Date
    Aug 2002
    Posts
    10
    Quote Originally Posted by Chimp8471
    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
    reference control on subform like so

    Forms![main form name]![subform control name].Form![control name]

    use in an if statement and set your label "me.label.visible = true or false depending on what you want.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •