All,

I need to change the size of a field via DAO. I know how to delete a field and then create a new one, but what I can't seem to work out is how to create a new field, copy the data from the old field and then rename the new field.

So, I have a field which is 50 characters in size which contains data and I want to make the field 75 characters wide, BUT, retain the existing data.

Could anyone give me a few pointers ?

Thanks.

Chris Swann