var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Alter Column syntax
Does anyone know how to alter a column format?
Example I want to add a new column in SQL. The new column name is Cost. I want it to have a "standard" format single type
In my alter command I can only specify the type but I don't know how to specify the format
Alter table tblCustomers ADD Cost single;
I want it to have a format of "Standard" of number(Integer) type.
Any help or comments are greatly appreciated
I don't think you can change the format throug the Alter Table
You can add new columns or drop old ones
Docmd.runsql "ALTER TABLE wp ADD COLUMN yourFiledName single"
Docmd.runsql "ALTER TABLE wp ADD COLUMN yourFiledName2 string (27)"
To change the format, try to use the TableDef Objek
how would i use the TableDef object?
Just have look to that object in the help, there are also examples