If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2003 Checkbox Triple State
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 |
#2
|
|||
|
|||
Access 2003 Checkbox Triple State
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 "Mike Sorel" wrote in message ... 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 |
#3
|
|||
|
|||
Access 2003 Checkbox Triple State
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 "Jeff Boyce" wrote: 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 "Mike Sorel" wrote in message ... 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 |
#4
|
|||
|
|||
Access 2003 Checkbox Triple State
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 -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Mike Sorel" wrote in message ... 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 "Jeff Boyce" wrote: 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 "Mike Sorel" wrote in message ... 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 |
#5
|
|||
|
|||
Access 2003 Checkbox Triple State
Thanks Jeff,
That is the answer. It also answers why some of the other control properties (border styles, etc) were behaving strangely. Regards Mike "Jeff Boyce" wrote: 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 "Mike Sorel" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|