Page 1 of 3 123 LastLast
Results 1 to 15 of 40
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How do I conditionally display a Label in a report, based on whether or not a checkbox is true or false?

    I have a report that groups the results by whether the status of the record is "Active" (checkbox = true) or "Inactive" (checkbox = false). However, instead of just displaying the checkbox in the report as a group header, I would rather put a label there, such as "All Active Items" and "All Inactive Items", depending on whether or not the Active checkbox is true or false.

    I tried the following code in the On Load event of the form, but I don't get the correct results:

    Code:
    If Me.Active = True Then
       Me.AllActive.Visible = True
       Me.AllInactive.Visible = False
    Else
       Me.AllActive.Visible = False
       Me.AllInactive.Visible = True
    End If
    Thanks for your help.

    JoeK

  2. #2
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How do I conditionally display a Label in a report, based on whether or not a checkbox is true or false?

    I have a report that groups the results by whether the status of the record is "Active" (checkbox = true) or "Inactive" (checkbox = false). However, instead of just displaying the checkbox in the report as a group header, I would rather put a label there, such as "All Active Items" and "All Inactive Items", depending on whether or not the Active checkbox is true or false.

    I tried the following code in the On Load event of the form, but I don't get the correct results:

    Code:
    If Me.Active = True Then
       Me.AllActive.Visible = True
       Me.AllInactive.Visible = False
    Else
       Me.AllActive.Visible = False
       Me.AllInactive.Visible = True
    End If
    Thanks for your help.

    JoeK

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How do I conditionally display a Label in a report, based on whether or not a checkbox is true or false?

    I have a report that groups the results by whether the status of the record is "Active" (checkbox = true) or "Inactive" (checkbox = false). However, instead of just displaying the checkbox in the report as a group header, I would rather put a label there, such as "All Active Items" and "All Inactive Items", depending on whether or not the Active checkbox is true or false.

    I tried the following code in the On Load event of the form, but I don't get the correct results:

    Code:
    If Me.Active = True Then
       Me.AllActive.Visible = True
       Me.AllInactive.Visible = False
    Else
       Me.AllActive.Visible = False
       Me.AllInactive.Visible = True
    End If
    Thanks for your help.

    JoeK

  4. #4
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How do I conditionally display a Label in a report, based on whether or not a checkbox is true or false?

    I have a report that groups the results by whether the status of the record is "Active" (checkbox = true) or "Inactive" (checkbox = false). However, instead of just displaying the checkbox in the report as a group header, I would rather put a label there, such as "All Active Items" and "All Inactive Items", depending on whether or not the Active checkbox is true or false.

    I tried the following code in the On Load event of the form, but I don't get the correct results:

    Code:
    If Me.Active = True Then
       Me.AllActive.Visible = True
       Me.AllInactive.Visible = False
    Else
       Me.AllActive.Visible = False
       Me.AllInactive.Visible = True
    End If
    Thanks for your help.

    JoeK

  5. #5
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How do I conditionally display a Label in a report, based on whether or not a checkbox is true or false?

    I have a report that groups the results by whether the status of the record is "Active" (checkbox = true) or "Inactive" (checkbox = false). However, instead of just displaying the checkbox in the report as a group header, I would rather put a label there, such as "All Active Items" and "All Inactive Items", depending on whether or not the Active checkbox is true or false.

    I tried the following code in the On Load event of the form, but I don't get the correct results:

    Code:
    If Me.Active = True Then
       Me.AllActive.Visible = True
       Me.AllInactive.Visible = False
    Else
       Me.AllActive.Visible = False
       Me.AllInactive.Visible = True
    End If
    Thanks for your help.

    JoeK

  6. #6
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How do I conditionally display a Label in a report, based on whether or not a checkbox is true or false?

    I have a report that groups the results by whether the status of the record is "Active" (checkbox = true) or "Inactive" (checkbox = false). However, instead of just displaying the checkbox in the report as a group header, I would rather put a label there, such as "All Active Items" and "All Inactive Items", depending on whether or not the Active checkbox is true or false.

    I tried the following code in the On Load event of the form, but I don't get the correct results:

    Code:
    If Me.Active = True Then
       Me.AllActive.Visible = True
       Me.AllInactive.Visible = False
    Else
       Me.AllActive.Visible = False
       Me.AllInactive.Visible = True
    End If
    Thanks for your help.

    JoeK

  7. #7
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How do I conditionally display a Label in a report, based on whether or not a checkbox is true or false?

    I have a report that groups the results by whether the status of the record is "Active" (checkbox = true) or "Inactive" (checkbox = false). However, instead of just displaying the checkbox in the report as a group header, I would rather put a label there, such as "All Active Items" and "All Inactive Items", depending on whether or not the Active checkbox is true or false.

    I tried the following code in the On Load event of the form, but I don't get the correct results:

    Code:
    If Me.Active = True Then
       Me.AllActive.Visible = True
       Me.AllInactive.Visible = False
    Else
       Me.AllActive.Visible = False
       Me.AllInactive.Visible = True
    End If
    Thanks for your help.

    JoeK

  8. #8
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How do I conditionally display a Label in a report, based on whether or not a checkbox is true or false?

    I have a report that groups the results by whether the status of the record is "Active" (checkbox = true) or "Inactive" (checkbox = false). However, instead of just displaying the checkbox in the report as a group header, I would rather put a label there, such as "All Active Items" and "All Inactive Items", depending on whether or not the Active checkbox is true or false.

    I tried the following code in the On Load event of the form, but I don't get the correct results:

    Code:
    If Me.Active = True Then
       Me.AllActive.Visible = True
       Me.AllInactive.Visible = False
    Else
       Me.AllActive.Visible = False
       Me.AllInactive.Visible = True
    End If
    Thanks for your help.

    JoeK

  9. #9
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Try moving the code to the On Format event.

  10. #10
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Try moving the code to the On Format event.

  11. #11
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Try moving the code to the On Format event.

  12. #12
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Try moving the code to the On Format event.

  13. #13
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Try moving the code to the On Format event.

  14. #14
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Try moving the code to the On Format event.

  15. #15
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Try moving the code to the On Format event.

Page 1 of 3 123 LastLast

Posting Permissions

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