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

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: Filter by form problem with Yes/No Data and SQL Server
    ... 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 ...
    (comp.databases.ms-access)
  • Re: To check all items in a subform
    ... Microsoft Access MVP ... Try a Refresh just before you run the query. ... AND on the subform too... ... Assuming the subform checkboxes are True/False Boolean... ...
    (microsoft.public.access.forms)
  • Re: To check all items in a subform
    ... Microsoft Access MVP ... Try a Refresh just before you run the query. ... AND on the subform too... ... Assuming the subform checkboxes are True/False Boolean... ...
    (microsoft.public.access.forms)
  • 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: Checkbox (default to no) - must be checked before saving/exiting
    ... If you literally mean "all checkboxes" you could alternatively write: ... dim ctl as control ... Microsoft Access MVP ... Yes/No boxes on the form that are defaulted to No. ...
    (microsoft.public.access.forms)