Check boxes on querys

[Cathy]

i have a query about search for if a check box is ticked or not on a query.
On one database if the box is ticked it is shown as -1 when i do a search,
which is great as i can just search for those with -1 in it.
However we have another database designed by someone else where in the
search it is just showing as a box with a tick on it, -1 doesnt work, Is
Null, Is Not Null doesnt work, does anyone know how to define the criteria on
this checkbox that it picks up just those that are ticked/or not ticked?

Many thanks

 

[Steve Schapel]

Cathy,

I am surprised that using -1 in the criteria doesn't work. In Access,
-1 is the default value for Yes/True. However, it can be any integer,
so it is a good idea to use <>0 instead. Whether you actually see a
checkbox, or a numerical value, or Yes or True or On etc, is a
formatting thing, which should not affect the value. For example, this
can be affected by the Format and Display Control property settings for
the field in design view of the table. This is assuming you are talking
about the query datasheet itself. If you are talking about working with
a form, it is possible that the "box with a tick" is not really a
checkbox. So sorry, I know I haven't directly and confidently answered
your question, but can you please have another try.