Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a checkbox [Inactive] on a report that I would like to make visible if the value is -1 and not visible if the value is 0.

    How do I code this and where do I put the code to make it work.

    I have had no luck trying to figure it out on my own.

    Thanks for the help.

    Paul

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    You can set the visibility in either the OnPrint or OnFormat event of the section of the Report that contains the checkbox

    Code:
    me.checkInactive.visible = (me.inactive=true)
    That code is a short way or writing

    Code:
    if me.inactive=true then
     me.checkinactive.visible=true
    else
     me.checkinactive.visible=false
    
    end if
    You need to adjust the code for the actual name of the checkbox control.
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks. That worked well.

    Paul

Posting Permissions

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