Check Box seems to have 3 states as default

Hey THX for the reply! I didn’t assign any thing to the reference state on the data tab, but my understanding is should be true or false if you fill that out, that didn’t work either. The check box works fine, when you place a check in it, I can qualify search’s using, “is not empty”. But if you remove it, the check, it still thinks the check is there. So the effective result is once you check the box, it will stay checked on a form even if not checked. If you view it in the underlying table, query or table view, it has three visible states, checked, filled (a black square) and empty or blank. From here you can “UN-Check” (which is the square filled state) the check box but not from the form.

I am using LO 4.204 and HSQLDB 2.3 in a multi user state, if that makes any difference

Again I appreciate any thoughts or help here!

Thx Frofa

I chose the Booleen or Yes/No Field as the bound field type, which is what I have read
is correct. It seems to have three options itself however.

The only way it seems to work properly is to select the tristate mode on the form,from the tab on it’s control as you have displayed. That allows you to step through all three states from the form without going to the underling table.

Answering No or leaving it in it default state (Non Tristate) seems to allow you to use it only once from a form.

It works, just a little weird having three answers in a field what should have only two.