I'm using SQL Server 2000 with Access 2000/2002/2003 (file is
formatted as 2000).

I have a field in a table in SQL Server that is linked to the Access
file.  The field was originally a bit, but I have also tested with
tinyint.  The field allows nulls and the default is null.

I would like to have a combobox containing the values "yes" and "no"
bound to the field.  When the value is Null, I would like nothing to
be selected.  When the value is 0 or 1, I would like "no" and "yes" to
be selected, respectively.

After googling the archives for over an hour, I have found posts
stating that Access doesn't play well with bit fields containing null,
so I switched to tinyint.  That seems to avoid the complaints from
Access, but it is interpretting null as 0 and selecting "no".

Is there a way to do what I want?

Thanks,