Check Boxes in Access

[JPRoy392]

When I connect checkboxes in VB to Access, I have to use this code to make sure that the checkboxes are null:


For Each ctl In frmOrderNewSheet.Controls
If TypeOf ctl Is CheckBox Then
ctl.Value = 0
End If
Next


The value of the check boxes when the form is loaded is 0, yet without this code, VB automatically makes the boxes grayed with checks. This is annoying. Any Suggestions?

[JHausmann]

I'd look in your code, it sounds like something is initializing the enabled property and the value property (either specifically or by default).

[whittam]

I had a similar problem but solved it by using option buttons and setting them to the triple state, when I loaded the form they appeared blank and were then ready for use.

Only thing is you have to reset it if the form is used over again before being reloaded