Alter/Change Text Column Field Size

[Ross]

How can I change the size of a text column "Field4" from 3 to 50 on a
recently imported table? I need to do this using VBA.

Thank you

Ross

 

[Marshall Barton]

How can I change the size of a text column "Field4" from 3 to 50 on a
recently imported table? I need to do this using VBA.

sql = "ALTER TABLE thetable ALTER COLUMN Field4 Text(50)"
Set db = CurrentDb()
db.Execute sql, dbFailOnError
Set db Nothing

 

[Ross]

Marsh,

Awesome!

Thanks

sql = "ALTER TABLE thetable ALTER COLUMN Field4 Text(50)"
Set db = CurrentDb()
db.Execute sql, dbFailOnError
Set db Nothing