Hi:

Try executing SQL like this in VBA

"Alter Table [Category List] Alter Column [ComponentID] Text(10)"

This changes column ComponentID to Text 10 in table Category List.

Regards,

Naresh Nichani
Microsoft Access MVP