delete property of a field 1

[samotek]

I am renaming the fields in a table:
tdf.Fields("F1").Name = "Students"
My question is, how can i change the property of the field, since it is a text,and i want to make it number.

 

[Remou]

Hi
I do not think you can, with TableDefs. If certain conditions are met, you can use Alter Table:
[tt]SQL = "ALTER TABLE table1 ALTER COLUMN Field1 INT"
DoCmd.RunSQL SQL[/tt]

However, from some of your questions, it looks like it might be easier for you to run an append query programtically.