Modifying Table Property with SQL 1

[EddyLLC]

I am trying to change the Decimal places of a table field from 2 to 4 using the following code only to receive a syntax error. Can anybody tell what I have done wrong? Thanks
Eddy


strSQL = "ALTER TABLE tbl2 ALTER COLUMN Factor DecimalPlaces(4)"

 

[Golom]

DecimalPlaces" is a field property but the "ALTER" statement is expecting a data type. If you are using DAO then you need

db.TableDefs("tbl2").Fields("Factor").Properties("DecimalPlaces").Value = 4

 

[EddyLLC]

Man your good! Thanks for curing my headache