changing field prop's or copying data to another table
Hi Peter,
Once a field has been appended to a tabledef, there is no way to change
its size or datatype with code. However, you could append a new field to the
same table that is the size and/or type you desire, copy the data, and drop
the original field.
Even easier would be to open the table in design view and change the
field's size with Access. Is there some reason why this is not an option?
--Doug
Quote:
> hi there,
> I have a table that i am trying to update 6 fields but the field size is
two
> small. Is the a way of change the field size in VBA or will i have to
create
> an update query to copy from the old table to another table with the field
> sizes changed.
> Could some-one please help me out
