Setting table field property in visual basic

[Guest]

Is it possible to update field properties of a table using visual basic?
Specifically, during vb I am creating fields in a table, all of type
CURRENCY. Several of these fields I would like to display during table
export as a GENERAL NUMBER. I create the fields using the .fields.append
..CreateField("fldname",dbCurrency)
I can run through the tbldef and pick each field I want to change, I just do
not know the actual command to change it.

Thanks!

 

[Guest]

Display where?
If on a form or report, you should be changing the formatting there and not
in the table.

-Dorian

 

[Guest]

During Export (to Excel), the field displays based on field settings in the
table. The field currency works for the data in the table, however, when
exporting I want to show the data without a dollar sign. The simple method
for this would be to edit the FORMAT property of the table and change it to
General Number.
Since this table is built on-the-fly and varies in the number and type of
fields, I cannot setup an Export Specification that would help me with this.

So, my question is, in visual basic, is it possible using the
tabledef/field/property methods to edit and update the FORMAT property of a
field in a table.