Changing Field Data Type (1 Viewer)

[KDg]

does anyone know how to change the data type of a pre-existing field in a table from text to long in VBA?

 

[Travis]

You know that type of question plaqued me for months. This is what I found out. There are properties that you can change in code (e.g.; AllowZeroLength) but the type and size are not doable. You can however recreate the field in the table run an update query to append the old field to the new and then remove the old field through VBA. This method only becomes a problem if you use the fields ordinal position somewhere in you code. Another method is to recreate the entire table in VBA and Append the data that way and then delete the old table.

 

[KDg]

Thanks Travis, I've taken your advice and went for the appending fields approach, works like a dream. Annoying you can't change datatypes though, Cheers, Drew