Botton that checks all boxes

[sobrien1234]

I have a form with about 10 check boxes on it that are ticked when answering the questions. I want a button that someone can press that checks all the boxes at once - i.e. a "yes to all" button. I also want one that clears them all as well.

Can anyone suggest how to do this?

Thanks

 

[sobrien1234]

Whoops, I should have looked at your post more closely, you are using Access –suggested solution was intended for Excel. Ever so sorry about that.
I don’t have Access on my system & its been about 15 years since I have done anything using it.

You can try replacing procedure with following updated version

 Sub AllCheckBoxes(ByVal State As Boolean)    
    Dim ctrl As Control
    For Each ctrl In Me.Controls
        If ctrl.ControlType = acCheckBox Then ctrl.Value = State
    Next ctrl
End Sub

This is very much a guess – if does not work hopefully, another here can step in & resolve for you

So sorry.

Dave

No worries - thanks for trying!