Format field numbers after make table

[brianb]

I am running a Make Table query which includes a UDF to convert text to numbers (removing commas for thousands and brackets for negatives).

After it has run I can manually change the number column formats in the table to "Standard". Can I do this in code ?

I have tried putting Format() function in the UDF but, although it runs, the numbers remain unformatted.

I suppose I could delete all records from a preformatted table and make it an Append Query, but logic tells me there must be an easier way.

Thanks.