Results 1 to 6 of 6
  1. #1
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155

    Conditional Visiablity

    I am trying to have a combo box appear when a check box is checked.



    Current code:

    Code:
    If Me.FollowUp = "Whatever" Then
            Me.Combo40.Visible = True
            Me.[Department_Label].Visible = True
            Me.Text42.Visible = True
    
        Else
            Me.Combo40.Visible = False
            Me.[Department_Label].Visible = False
            Me.Text42.Visible = False
        End If
    

    What would be the proper word to put in the "Whatever" spot?

  2. #2
    Dee300 is offline Advanced Intermediate
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    12
    If FollowUp is the name of your checkbox field then "whatever" should be replaced with "True".

    With checkboxes, true means the box is checked, false means unchecked.




  3. #3
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155
    Code:
    Private Sub FollowUp_AfterUpdate()
    If Me.FollowUp = "True" Then
            Me.Combo40.Visible = True
            Me.[Department_Label].Visible = True
            Me.Text42.Visible = True
        Else
            Me.Combo40.Visible = False
            Me.[Department_Label].Visible = False
            Me.Text42.Visible = False
        End If
    End Sub
    This is what I have. I also have all the controls set to Visible and I have not inlcuded them in the Form_Load() Sub ...

    It still isnt working.

  4. #4
    Dee300 is offline Advanced Intermediate
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    12
    Copy (do not remove) the same code and put in the form's "on current" event.

  5. #5
    Dee300 is offline Advanced Intermediate
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    12
    If it is still not working try replacing the "true" with "-1"

  6. #6
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155
    The -1 worked. Thanks! I had tried almost everything from True/False to Yes/No lol

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Conditional Printing
    By anoob in forum Forms
    Replies: 28
    Last Post: 03-18-2011, 01:51 PM
  2. Conditional Summation
    By megabrown in forum Queries
    Replies: 15
    Last Post: 12-08-2010, 06:19 PM
  3. Conditional Formatting
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-30-2010, 09:31 PM
  4. conditional formatting right(..)
    By bbeernaert in forum Access
    Replies: 3
    Last Post: 08-25-2010, 12:33 AM
  5. Conditional Formatting
    By cevatyildiz in forum Forms
    Replies: 8
    Last Post: 04-30-2010, 12:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums