Access 2003 Checkbox Triple State


G

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
 
Ad

Advertisements

J

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
 
G

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
 
A

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
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top