Access boolean field with SQL

I am making an install script for my ASP Portal wich will create the tables, indexes, relationships and stored procedures and insert values. Almost everything is working fine with both Access and SQL Server, only one problem. When using "bit" as datatype (Field_name bit NOT NULL) a "Yes/No" Field is created but with a blank format..

All other data types workes fine (as far as I have seen) but I have problems with the booleans..


so, is there any other "boolean datatypes" I can use?


EDIT: thank you for the help!


Edited by Semikolon

I was thinking of that as one of two other solutions (the third is to use the tables scripts only on SQL Server and have the Access database already installed)

but a real boolean field would absolutely be the best



thanks for the answer anyways