How would I change a text field size from 2 to 20 using VBA thanks Nigel
N Nigel Bennett Feb 25, 2005 #1 How would I change a text field size from 2 to 20 using VBA thanks Nigel
N Naresh Nichani MVP Feb 25, 2005 #2 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
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
