 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / March 2005Non-selected checkbox state?
Doesn't a checkbox have a non-selected state? I'm using a combo box to designate "Please Select" "On State" "Off State" I thought that if a checkbox was never checked or unchecked it was ---Null? Depends upon how you set up the field that is bound to the checkbox. If it's a Yes/No field, then it has only two value possibilities: True or False. Unchecked means False. However, if the field is an integer type, then a checkbox control bound to this field can have its "Triple State" property set to Yes, which means that it can represent three value possibilities: True, False, or Null.  SignatureKen Snell <MS ACCESS MVP> > Doesn't a checkbox have a non-selected state? > [quoted text clipped - 5 lines] > I thought that if a checkbox was never checked or unchecked it > was ---Null? Checkbox or Combobox? Access allows three states or only two states for a checkbox value. The "Triple State" property of the checkbox control should yes to allow nulls. When set to No, it only allows a yes/no, true/false, -1/0 state, which defaults to 0 or false. Strange. I DO have it set to tripple state - But I added this field late. So, all existing records are automatically changing it to a zero state in my interface. but NEW records are at a null state. (which is what I desire) So I tried doing an update query to set all fields to NULL, but no go. it STILL sets my present records to 0. So as Ken Snell states... I think I need to change the field to a textbox integer value and allow nulls on the table. > Checkbox or Combobox? > > Access allows three states or only two states for a checkbox value. The > "Triple State" property of the checkbox control should yes to allow nulls. > When set to No, it only allows a yes/no, true/false, -1/0 state, which > defaults to 0 or false. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.