change field size

A

Ariel

I would like to change the size of a specific field from the default 50 to 80
in a sub routine I am writing. Can someone help?


Thanks

Ariel
 
A

Allen Browne

Execute an ALTER TABLE statement.

Example:
strSql = "ALTER TABLE MyTable ALTER COLUMN MyTextField TEXT(80);"
DBEngine(0)(0).Execute strSql, dbFailOnError

(Requires at least Access 2000.)
 
A

Ariel

Thanks Allen.

Allen Browne said:
Execute an ALTER TABLE statement.

Example:
strSql = "ALTER TABLE MyTable ALTER COLUMN MyTextField TEXT(80);"
DBEngine(0)(0).Execute strSql, dbFailOnError

(Requires at least Access 2000.)
Click to expand...
 
Top