Is there a way to change the datatype of a field in an Access database table through a SQL statement? I've found a why to do it by adding a new field to the table, copying the data from the field I want to change to the new field, deleting the old field and renaming the new field. This works except the new field is now the last field on the table. I want the field to stay in the same place in the table. Is there a way to do this with SQL or through VB code?

ALTER TABLE Table1 ALTER COLUMN Field1 Text (50);

I used this to change a field name 'Field1' in 'Table1' from a number data type to a text data type 50 characters long.

HTH,

Bob

That works! Thanks!