CheckBox Help 1

[SILLEYJ]

I have a form with a checkbox, The box has a label of Documentation Waiver. If the box is checked is there a way to grey out the rest of the form?? If the checkbox is left alone the form appears normal?

Thanks in Advance
Jeff

 

[lespaul]

How about in the On Click event check to see if it's checked or not checked. If checked you set the enabled property of the other objects to false, if not checked then set them to true?

leslie

 

[SILLEYJ]

OK that sounds reasonable but how would I go about doing that. I am very new to Access. I know how to check the properties and see where it says ON CLICK but after that I am kind of Lost.

Jeff

 

[lespaul]

Ok, one slight correction, you should put it in the AfterUpdate event, not the onClick event.

Go to the properties of the checkbox, select the AfterUpdate Event and press the [...] to get to the Code Builder. When the code window opens it will have something like:

Private Sub Check0_AfterUpdate()

End Sub

in between the Sub and the End Sub you'll need something like this:

  If Check0.Value Then
    Text2.Enabled = False
  Else
    Text2.Enabled = True
  End If

Where Check0 is the name of your Checkbox and Text2 is the name of the item to disable.

HTH

Leslie

 

[SILLEYJ]

Thank You Very Much worked Perfectly.

Jeff