Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2005
    Location
    New England
    Posts
    35

    Unanswered: Codes for Reports

    I have a report that lists various medications. I am wanting a text box to only be visible when the end date is not nulled. I have this code:
    If IsNull(Me!EndDate) Then
    Me!Text42.Visible = False
    Else
    Me!Text42.Visible = True
    End If

    Which works along the same idea, however if only one of the lines meets the criteria it follows it for ALL the records. Is it possible (and how) to make this only show for the records that meet the criteria? I currently have the code linked to On Open Event of the report (it happens to be a subreport of another report). Thanks for all help and advice.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Move it to the OnPrint or OnFormat event of the section in which the control resides (probably the detail section).
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Aug 2005
    Location
    New England
    Posts
    35

    Thanks a million

    worked wonderfully

Posting Permissions

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