[AccessD] ALTER TABLE in Access

Mark, I've never tried and never seen the syntax for doing so. 

I would try:

ALTER TABLE MyTable ALTER COLUMN Field1 Text(255) , Field2 Text(xxx), Field3
Text(xxx)...

Just a total guess though.

Susan H. 

I have a table in Access where I want to increase field sizes of text
fields.  Here is my SQL: