On Thu, 17 Apr 2003 19:09:33 +0100, "Brian Gallagher"
Quote:
>Oh and I mean by code of course!
>> How can I change the size of a field in a table.
>> Is there a way to do it without creating a new field and then moving the
>> data and deleteing the old and and then renaming the new? (PHEW THAT WAS
>A
>> LONG QUESTION!)
>> Brian
Brian:
AFAIK the field size of a field in a table is read only after initial
creation, thus, you have to go through the create, move data,
delete process, etc.
You can use DAO or ADO or just use SQL commands (like ALTER) from the
currentdb.execute methods under DAO.