Check Box Values

[CementCarver]

After doing some research on using check boxes, I found that the check box valued actually has three values: -1(Yes), 0(No) and Blue (Undetermined).

So if my client accidentally selects the check box, but then changes their mind, there's no way of putting the value back to being undetermined. After it's been selected once, it can only then be -1 or 0.



Is there any way of setting it back to being undetermined?

CementCarver

[June7]

Sounds like triple state property. I've never used this. I avoid yes/no fields for user data entry. Review http://office.microsoft.com/en-us/ac...001232798.aspx

[rzw0wr]

Usually when using a check box, the box is set to a default in the table.
I would want the data to be something I could control. Either on or off, Yes or No, True or False.

Null or Undetermined does not tell me anything.

A side note here: As june7 stated check boxes can usually be replaced with the idea the "If data is present = Yes" Else NO" type of logic.


Dale