Access 2003 Checkbox Triple State

[Guest]

The Checkbox does not appear greyed out when the value is Null (it looks
exactly the same as for the value of 0).
I have a checkbox on a form that is bound to an integer field. I have set
the Triple State property of the Checkbox to Yes. Clicking the Checkbox
cycles through the values -1, 0 & Null and the correct values are stored in
the database.
Thanks in advance.
Mike

 

[Jeff Boyce]

Mike

Does the underlying field (in the table), or the control on the form have a
default value set?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hi Jeff,
I have tried it with and without a default value, there is no difference in
this behaviour with or without.
At the moment I have no default on the control and no default on the field.
Thanks
Mike

 

[Allen Browne]

Since it actually works correctly, this has to be a display issue.

Try turning off the option for Themed controls. From memory, it's under:
Tools | Options | Form/Reports

 

[Guest]

Thanks Jeff,
That is the answer. It also answers why some of the other control
properties (border styles, etc) were behaving strangely.
Regards
Mike