Data Definition Query

[RichB]

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

 

[Fornatian]

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?

 

[RichB]

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