I don't think you'll be able to do this in one go, I would try:
SQL1. ALTER Table ADD Column Field Type and size
SQL2. UPDATE query and move records to new column
SQL3. ALTER Table DROP original column.
From: mike wilson [mailto:chopswil@h...]
Sent: 19 July 2001 15:44
Subject: [vba_access] Re: SQL statement in VB for Access
Tried it, didn't work. Same error
> You can write u'r query to modify u'r column..
> sChangeDB = "alter table Address alter column " _
> & "[Street]" & " text(40)"
> I think u will succeed with this code...