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
