Alter/Change Text Column Field Size

  • Thread starter Thread starter Ross
  • Start date Start date
R

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
 
Ross said:
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.
Click to expand...


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

Awesome!

Thanks


Marshall Barton said:
sql = "ALTER TABLE thetable ALTER COLUMN Field4 Text(50)"
Set db = CurrentDb()
db.Execute sql, dbFailOnError
Set db Nothing
Click to expand...
 
Back
Top