Changing data types in a macro

[Thuy Pham]

I have set up a macro to run my queries, however, i need to change the data
type of one of the tables created from "memo" to "text". How can i
incorporate into my macro?

Would i need to add a sql statement, if so can i use the RunSQL function in
the macro and what code will i need to use.

Thanks

 

[KARL DEWEY]

Why use a macro? Just open the table in design view and change it.
Are you planning on changing it often? Why? You probaby will lose data if
you change.

 

[Thuy Pham]

Hi Karl,

As i need to run a series of queries, i have created a macro to run this in
sequence and therefore do not want to have to manually amend. Is there a
macro to change type automatically?

 

[KARL DEWEY]

A macro is a method to create a program to do multiple step many times
without having to type them each time. Changing a memo field to a text field
is something you will only do ONE time so what is the point in try to write a
program?

 

[Thuy Pham]

Unfortunately, I have 4 macros to run for each individual report. It would be
good not to have to start, stop, change data type and then run remaining
macros again in the same way. If there is no macro function then this will
have to be a manual processs.

Thanks for your help.