Changing a field size

[Nigel Bennett]

I ahve added a field using code and I need to change the
size of it from 100 to 150 Characters.

How would this be done in code

Nigel

 

[Alex Dybenko]

you have to create a new field, size 150, run update query to copy data from
old to new field, then delete old and rename new to old

 

[Lance McGonigal]

I think you can also use the ALTER TABLE sql command. I've used it before.

 

[Alex Dybenko]

yes, but not in all access versions