Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Aug 2004
    Location
    Withyham, Sussex, England
    Posts
    121
    Thanks
    2
    Thanked 1 Time in 1 Post

    Thumbs up Control visibility of text boxes etc on a form with a checkbox

    Good day, I have a database inherited from a new client (Access 2007) they currently have a form on which they would like to have a few extra text boxes on the form if a checkbox is ticked and not visible if not ticked. Is this possible? If yes can you point me to an example of the code and where to put it. Thanks.

    Found the answer. Me.NameOfComboBox.Visible = Me.NameOfCheckBox placed in Event On Click
    Last edited by gws; 2011-11-15 at 11:02. Reason: Solution found

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    I am sure you know, but if you are scrolling through records on the form, then this code needs to go on both the After Update Event of the check box, and also the On Current event of the form.
    Andrew

Posting Permissions

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