@bullfrog83
Not necessarily.....I just mentioned that Yes/No fields in Access have a three logic state namely true false and null. Practically speaking it is the same as this....if you click the tick it is true if you click the tick and click it off again it is false. ...but if you never click it all and have NO default it will be null in the table row. Now what happens when you try and upload that to SQL Server as the natural equivalent which maps the 0 or 1 true/false BIT field in SQL Server it makes the server cough and reject your data upload. The nulls is a known problem on conversion. A quick search on the web will show you all sorts of discussions about this, It is not grave so dont let it concern your choice too much.
Don,t let this put you off, Its not insurmountable, its not major, it is just burdensome sometimes to go through a very sophisticated large db hunting out the upgrade problems thats all...If you want to use boolean then fine, go ahead and use it, just be aware about the providing the default in your table. If you do that then you will have no issue.