Can I check multiple check boxes with one click?

Can I check multiple check boxes with one click?

Post by dG9iZXN1c » Sat, 13 Aug 2005 09:03:02


I have a form with multiple check boxes in two different categories. Usually
only one or two check boxes need to be checked per record (so I have default
set to unchecked), but frequently I'll need to check all boxes in a given
category which takes forever.

Is there some way to install a device (or master check box) that will check
all boxes in a given category with one click?

Thanks in advance!

 
 
 

Can I check multiple check boxes with one click?

Post by Douglas J. » Sat, 13 Aug 2005 09:38:17

Dim ctlCurr As Control

For Each ctlCurr In Me.Controls
If TypeOf ctlCurr Is CheckBox Then
ctlCurr = True
End If
Next ctlCurr

will check all checkboxes on a form.

--
Doug Steele, Microsoft Access MVP
http://www.yqcomputer.com/
(no e-mails, please!)