Results 1 to 3 of 3
  1. #1
    GoneFusion is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2010
    Posts
    1

    select multiple checkboxes in access 2003?

    I am entering data into a access fourm that has multiple collumns with checkboxes. Is it possible to select or hightlight them all and check them off or on at the same time?

    Changing the fourm codeing/design is not really an option but if its the only way to do this let me know.

    Thanks

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,921
    AFAIK you have to select each one separately. If they are in sequence then I would think the tab key and the space bar would make fast work of them.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,684
    I don't know a UI way either. One code option:

    Code:
      Dim ctl As Control
    
      For Each ctl In Me.Controls  
        Select Case ctl.ControlType
          Case acCheckBox
            ctl = True
        End Select
      Next ctl
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 47
    Last Post: 06-17-2010, 03:04 PM
  2. Preventing multiple checkboxes
    By emerywang in forum Forms
    Replies: 2
    Last Post: 01-26-2010, 01:43 PM
  3. Replies: 1
    Last Post: 03-01-2009, 09:53 AM
  4. Replies: 1
    Last Post: 02-25-2009, 07:29 PM
  5. Replies: 1
    Last Post: 09-06-2006, 11:48 AM

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 - Senior Forums