Alter Column Definition

[jeancake]

Does anyone know the Alter Column command to change a Table Column definition from a character to a "Yes/NO" field?

 

[Norie]

The general code to modify the datatype of a column is this.

ALTER TABLE table_name
MODIFY COLUMN column_name datatype

However I'm not sure if it's possible to use SQL in Access for what you want to do, you might need to alter the column via the table's TableDef.

 

[jeancake]

I've been able to use it in access using SQL to change other data types (# to currency , etc) but I don't know what the datatype name for 'Yes/No' is.

 

[Norie]

That's kind of the problem, I think the Yes/No datatype isn't a 'standard SQL' datatype.

Mind you I think I saw some sort of workabout earlier, I'll have another look.

 

[Micron]

The type is Boolean (data type number is 1)
try "ALTER TABLE tblName ALTER COLUMN fieldName YesNo"
If you want to format it as other than Yes/No (True/False, On/Off) , I think you will have to use DAO.