Re: Filter by form problem with Yes/No Data and SQL Server

As the value for False in both cases is 0, structuring your test to use Not
False or <> False works well. That, of course, is simply another way of
specifying <> 0, because the value of the builtin Constant False is 0.

Larry Linson
Microsoft Office Access MVP

"Rick Brandt" <rickbrandt2@xxxxxxxxxxx> wrote in message
news:3bhHj.226$Gq7.188@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Jim Mandala wrote:
Thanks for the reply. I forgot to mention that I am using ODBC to
connect to the SQL server.

The Checkboxes on the normal Form map to 0's and 1's in the data
table. I.e. True = 1. However, when I use the Access' "Filter By
Form" function, it seems to open a 'copy' of the form. The Checkboxes
on this form automatically create a filter, but every checked Checkbox
creates a True = -1; which is the Access standard for True/False data.

Two different data standards... Same Microsoft... Does Bill Gates have
too much money?

Yep, I've seen this issue and not just in filter-by-form. The only 100%
reliable tests for a bit field from Access is =0 and <>0. Testing for -1
often does not work and testing for 1 often does not work. Yes/No,
True/False, etc., are equally problematic.

When testing a CheckBox *control* bound to a bit field you can usually use
any of the normal tests as you would with an Access table, but when
testing the actual field value just stick with =0 or <>0. They always
work.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com



.

Relevant Pages

  • Re: Filtering by Check Boxes
    ... Did you use checkboxes from the Forms toolbar or from the Control toolbox ... If you delete all the checkboxes, maybe you could just format the cell nicely. ... And format that range of cells as Wingdings. ... And you can always filter for that funny character. ...
    (microsoft.public.excel.misc)
  • RE: FILTER REPORTS USING MULTIPLE CRITERIA
    ... what i want to do is to filter my report using multiple attributes.. ... I used checkboxes for PROJECT STATUS so that I can choose one or more than ... "amsuria" wrote: ...
    (microsoft.public.access.formscoding)
  • RE: FILTER REPORTS USING MULTIPLE CRITERIA
    ... examples on how to limit a report output based on a multi-select list box. ... what i want to do is to filter my report using multiple attributes.. ... I used checkboxes for PROJECT STATUS so that I can choose one or more than ...
    (microsoft.public.access.formscoding)
  • Re: how do i filter check boxes?
    ... Select the range that would have held the checkboxes. ... And format that range of cells as Wingdings ... Or you can filter by blanks and non-blanks. ... outstanding and one column for completed. ...
    (microsoft.public.excel.misc)
  • Re: IE6 Internet Options Content AutoComplete Settings
    ... Microsoft Online Partner Support ... >Subject: Re: IE6 Internet Options Content AutoComplete Settings ... >Disregard, group policy issue. ... >> passwords" checkboxes are both greyed out. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)