Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2006
    Posts
    71
    Thanks
    1
    Thanked 0 Times in 0 Posts

    hiding labels (2003)

    Is there a way to hide or show a label on a report based on the content of the control associated with the label.
    Example: If control gb2 is null then hide labelgb2
    The report is called via a macro

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: hiding labels (2003)

    You can write code in the On Format event of the section that contains the control and the label. For example, if the control and label are in the Detail section:

    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me.labelgb2.Visible = Not IsNull(Me.gb2)
    End Sub

  3. #3
    Star Lounger
    Join Date
    Feb 2006
    Posts
    71
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: hiding labels (2003)

    Got it. Thank you

Posting Permissions

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