Check Box Triple State feature

[Anthony]

Hi,

I have a need for the triple state feature on some check
boxes, however even though the feature is active, on NULL
values the box still appears as a "FALSE" value.

I have checked this making sure the values are toggling
between "TRUE", "FALSE", "IS NULL" but the box is
behaving like the feature is off.

Any ideas?

Cheers.

 

[Ken Snell]

Be sure that the field to which the checkbox is bound is set to integer, not
to Yes/No (or true/false).

 

[Anthony]

I have found the error - it is generated by having the
boarder format set to other than solid. When set to
transparent, the check box (same goes for option buttons)
is no longer 3D looking and the null value is shown with
a shade.

 

[TC]

You may be missing Ken's point. Be aware that boolean (yes/no) table fields
can never be Null, in Jet. They can only be True, or False. So there is no
point binding a triplestate checkbox to a boolean table field, in Jet.

HTH,
TC