ALTER TABLE syntax error

[ossse]

I am trying to change the data type of a column. I have tried the following;

DoCmd.RunSQL "ALTER TABLE ZEvaluate ALTER COLUMN PM Basis MEMO;"

CurrentDb.Execute "ALTER TABLE ZEvaluate ALTER COLUMN PM Basis MEMO;"

For both I get a Syntax error. Do you know what I am doing wrong.

 

[PWise]

try

ALTER TABLE ZEvaluate ALTER COLUMN [PM Basis] MEMO

 

[ossse]

I've now tried that and it still does not work. This doesn't make sense to me!!! What is wrong with the code?