I have a data definition query and I am using and ALTER TABLE statement (below). I want to add a MEMO field type but it does not work. Can this be done? If so HELP!

ALTER TABLE TSS ADD COLUMN remarks MEMO (64000)


Rich

RichB,

I ran this from code and it worked OK

Dim dbs As Database
Set dbs = CurrentDb()

dbs.Execute "ALTER TABLE Table1 " _
& "ADD COLUMN Remarks MEMO;"

Does that help?

Thank You,:) I figured it was simple, just couldn't put it together.