TripleState checkbox

[KarenH]

I have a form with several checkboxes. The fieldtype in the table for them
is "Yes/No". There is an option in properties to make it a triple-state
checkbox, so that it can be checked, unchecked or grayed out (null).

When I change the property to triplestate, and then try and click one of the
boxes, I get the error message "The value you entered isn't valid for this
field. For example, you may have entered text in a numeric field or a number
that is larger than the FieldSize setting permits."

How can I make these checkboxes triplestate?

Thanks in advance.

 

[Marshall Barton]

I have a form with several checkboxes. The fieldtype in the table for them
is "Yes/No". There is an option in properties to make it a triple-state
checkbox, so that it can be checked, unchecked or grayed out (null).

When I change the property to triplestate, and then try and click one of the
boxes, I get the error message "The value you entered isn't valid for this
field. For example, you may have entered text in a numeric field or a number
that is larger than the FieldSize setting permits."

A Yes/No field can only be True (-1) or False (0) so Triple
State does not apply. When you try to set it to Null, you
get the (internal) validation rule error.

To use Triple State the field in the table must be a type
that can be 0, -1 or Null such as Integer or Long. Since
Integer and Long fields can obviously have values beyond 0
and -1, the automatic type conversion rules will be used
(all non-zero, non-Null values are considered True).
Toggling the check box will only set the 0, -1 or Null
values so there is very little to be concerned about.

 

[KarenH]

Thank you, this solution did exactly what I was hoping for!