Check boxes on querys

  • Thread starter Thread starter Cathy
  • Start date Start date
C

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
 
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.
 
Back
Top