Can I check multiple check boxes with one click?

G

Guest

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!
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing check boxes when a form closes 5
relating check boxes and labels 1
multiple check boxes for one field 8
Check Boxes 1
Many Check Boxes. 2
Variable Check Boxes 6
Create Check box that controls visibility of a text box or combo b 1
Expression builder Automating forms check boxes 2

Top