> 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!)

> Cheers in advance

> Brian

>> 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.

> >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.

> sorry,   forgot to sign my posting !!!!

> -------------
> Richard Killey
> www.comeandread.com/access

> latest article on my site shows
> how to use multi-select listboxes
> as criteria for reports