Change datatype to BIT yes/no 1

[jmodo]

I am trying to change the datatype of a column to yes/no. All I can find is the change to BIT(ALTER TABLE t column c BIT, is there a yes/no property to add on. I can't find anything.


Thanks,
-J

 

[Remou]

The type in Access is YesNo:

alter table t alter column c yesno

 

[Golom]

That's all you should need to do. Existing values will be converted to 0 (False) or -1 (True).

If you're trying to change the column format to "Yes/No" then you will need to look at the properties collection of a Field object.