Alter multiple columns types

[Del]

I need to change multiple columns from memo to text(30). The following code
works for a single column but i don't know how to add addition columns to the
code.

DoCmd.RunSQL "ALTER TABLE MyTable " & _
"ALTER COLUMN MyColumn1;"

 

[Jim Burke in Novi]

I'm pretty sure you need a separate ALTER statement for each column you want
to change.

 

[Marshall Barton]

I need to change multiple columns from memo to text(30). The following code
works for a single column but i don't know how to add addition columns to the
code.

DoCmd.RunSQL "ALTER TABLE MyTable " & _
"ALTER COLUMN MyColumn1;"

You can inly mess with one column at a time. Use a separate
query for each column.