Rx_
Nothing In Moderation
- Local time
- Today, 07:34
- Joined
- Oct 22, 2009
- Messages
- 2,803
A Checkbox control on a form can have three states when it
is bound to an Integer type number field.
While searching for the values, happened to notice that for Access 2008 the term threestate was easier to find than tristate
Any discussions for when to use a boolean field type (check box is yes or no) Vs a Threestate (Integer) can feel free to add here.
is bound to an Integer type number field.
Code:
The three visual states are :
checked Non Zero
not checked Zero
not checked gray Null
Any discussions for when to use a boolean field type (check box is yes or no) Vs a Threestate (Integer) can feel free to add here.