Change data type of an existing field using a Macro

[magaly]

I am wanting to change the data type of a field in an
exisiting table using a Macro. Any help would be greatly
appreciated!

-M

 

[Ken Snell]

I don't believe you can do this. In fact, the way it's done by ACCESS is to
create a new field in the table (the new field has the desired format), then
copy the data from the old field into the new field, then delete the old
field, and then move the new field back to where the old field was in the
field order.

This can be done by VBA if needed, but is there a reason why you can't just
do it manually?

What is the activity that you need to automate?