Issues with bit type fields after usizing tables to SQL SERVER 7.0

[roypython]

Hi.
your help is very appreciated.
I upsized MS ACCESS 2002 app to SQL SERVER 7.0 (tables only).
The problems:

1.ACCESS Queries that filter by checkboxes values on the form don't return correct results.
i.e. "SELECT fld1 FROM tbl1
WHERE fld2 = Forms![frm1].chkboxControl "
I guess that it has to do with the fact the bit type fields in SQL SERVER
7.0, do not "understand" true/false or yes/no (which are the possible
values of checkboxes on ACCESS forms).
Since this app contains hunders of queries and tens of forms
(that most of them contain checkboxes), I need to implement robust
solution across the app.
Any suggestions?

2. SQL SERVER 7.0 queries can't have in their GROUP BY statments , bit
fields.
i.e. "SELECT fld1 FROM tbl1
GROUPBY (bitFld)
HAVING(........) "
The solution that I came up with is to change the field data type in the
SQL SERVER to tinyINt.
but i'm not sure that it's the right way to go
Any suggestion?

Thanks
Roy