change field size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.)
 
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...
 
Back
Top