How do I change table field properties in a macro?

[tchamber]

I am working on a macro that imports and merges data from several sources. I
need to change the field format in a table from text to number. How do I do
this within a macro?

Thanks,

TC

 

[BMore via AccessMonster.com]

TC, don't, big chance in getting errors

Changing in a table a field from text to number is a one time action, which
will often result in errors (the otherway round makes more sense). Why would
you want a macro to do that for you?
Macros are not intended to correct table design mistakes.

You could fill an extra field (type Number) from your textfield by setValue
FieldNumber1 into Val(FieldText1)

Hope this helps,
Ben