1-0-DBNull

[Brenny]

Hi,

I'm using access database and a table has a boolean column.
I want to hold 1,0 and DBNull values in this column.
But I cannot DBNull value, how can I hold DBNull value in the access
database in boolean column?

 

[Benny Raymond]

I don't think boolean columns support dbnull

Hi,

I'm using access database and a table has a boolean column.
I want to hold 1,0 and DBNull values in this column.
But I cannot DBNull value, how can I hold DBNull value in the access
database in boolean column?

 

[Kevin Spencer]

You can't. A boolean column can hold one of exactly *two* values, true or
false. If you need a null value, use a numeric field.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
You can lead a fish to a bicycle,
but it takes a very long time,
and the bicycle has to *want* to change.

 

[Nicholas Paldino [.NET/C# MVP]]

Brenny,

When creating the table, you should set the "required" property for the
column to false. It should then accept null values.

Hope this helps.