[AccessD] change field size in code

ALTER TABLE tblname
ALTER COLUMN colname Memo
WHERE colname.value = "comment"

If this is just a one-time change, you should be able to run it from the SQL
View window -- you don't even need DAO. 

Susan H. 

Could someone give me some air code to change the field size from text to
memo if the word "comment" is in the field name?
Attached table. A2K. Preferably dao, I'm kinda old school.
A last minute change from the client.