How do set the default property using SQL?

[erkle]

In MS Access 2000, what SQL statement would I use to add a field to a table and set the default property. I know that to add a field I could use, "ALTER TABLE Customers ADD Comments Text 100;" but I don't know how to make this field have a default value of "test". Can anyone help?

 

[petersdaniel]

You cannot set a default value through SQL. It is a function of the Table Object. You can do this through VBA programming using ADO methods petersdaniel@hotmail.com
"If A equals success, then the formula is: A=X+Y+Z. X is work. Y is play. Z is keep your mouth shut." --Albert Einstein