Results 1 to 3 of 3
  1. #1
    Belxaviar1973 is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2010
    Location
    Bedford Park
    Posts
    1

    Unhappy Help - activate hidden control


    I want tosetup a form, that when a certain field is changed to yes, a hidden control is shown. But there there are multiple records and not all will be made "yes" at the same time.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    one solution is to do what you just said, and then use a form event to hide the control again when you move from record to record.

  3. #3
    michaeljohnh is offline More Human than Human
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    61

    An example

    As an example, here's what I did.

    I created 2 combo boxes named combo0 and combo2. Combo2 is the YES/NO control. You then put in an IF/Then statement in the ON CHANGE property of combo2. You need to identifiy each and every control that needs to be made visible. If they do not need to be make visible then do not code them and they will stay invisible. So make sure to have them be invisible to begin with. Controls have a Visible field in the Format tab near the top of the list.

    Here's the code for the On Change property of Combo 2

    Private Sub Combo2_Change()
    If Combo2 = "Yes" Then Combo0.Visible = True
    End Sub

    You would add in the same private sub any other controls that need to be toggled on.

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

Similar Threads

  1. Column Order, Hidden, Name
    By Eightball3 in forum Forms
    Replies: 1
    Last Post: 06-30-2010, 12:35 PM
  2. Hidden Attributes
    By NMJones in forum Access
    Replies: 1
    Last Post: 02-09-2010, 10:57 AM
  3. subform controls hidden
    By bkelly in forum Forms
    Replies: 0
    Last Post: 09-26-2009, 10:12 AM
  4. Problem when activate the Visual Basic Editor
    By milo in forum Programming
    Replies: 0
    Last Post: 05-21-2007, 09:05 AM
  5. Unhide Hidden Query
    By Valeda in forum Queries
    Replies: 2
    Last Post: 05-12-2006, 05:58 AM

Tags for this Thread

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