changing field size in tables

[craiglauren]

Is there no direct way to change field sizes in tables?
I've worked out the "createfield" route but I want to change the size of a field that already exists (short of creating a new field and then transporting the data from the old field over).

 

[SteveCulshaw]

Craig,

I'd suggest using SQL to alter the field size, have a look at the ALTER TABLE in the the Help file.

Cheers,
Steve C.

 

[MichaelRed]

Craig,

The 'Alter Table' command exists within Ms. Access and may be used to change the properties of fields. However, if the field is part of an index, there are some constraints.

On a different tangent, I am curious as to why you need to change the field size of a table - in code?

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over