Checkbox set to null value

[NT100]

I use VBA to build a form and need it to be refreshed (to clear all controls) once the user click a option of option group in it. I can't make it work to set the checkbox to null when I refresh the form even I set the control to triple state. I've read a lot of posts and white paper and found no solution on this.

I would be appreciated if you could suggest alternatives.

Thank you in advance.

 

[theDBguy]

Hi. If the checkbox is part of an option group, then set the option group to null, instead of the checkbox.

 

[isladogs]

Unlike SQL Server where boolean fields can be true, false or null, Boolean fields in Access tables can only be true or false. You can set an unbound checkbox to null but not if its a bound checkbox

 

[NT100]

Hi. If the checkbox is part of an option group, then set the option group to null, instead of the checkbox.

How?
Have any alternative solution?

 

[NT100]

Unlike SQL Server where boolean fields can be true, false or null, Boolean fields in Access tables can only be true or false. You can set an unbound checkbox to null but not if its a bound checkbox

I know. What alternative solutions does MS Access handle the business requirements
?

Thank you

 

[isladogs]

I know. What alternative solutions does MS Access handle the business requirements

Can you clarify the business requirements that depend on this as I can't think of any examples.

However, if it is essential to you, all I can suggest is to use a number field instead & set values to -1 (or 1) for true, 0 for false and null for your triple state requirement

In fact Allen Browne also suggests this as a workround: http://allenbrowne.com/bug-14.html

 

[theDBguy]

How?
Have any alternative solution?

Have you tried?


Me.OptionGroupName = Null

 

[NT100]

Thank you for the suggestions.

I decided to withdraw the use triple state of check box. It causes a lot of difficulty in implementations.

Best.