Reduce Size of Text Fields (Many Text Fields)

[hext2003]

I am working with a table with about 50 fields. Many of these fields are Text fields... And All Text Fields have a Size of 255. I want to shrink that down to about 25 or 30.

Is there are way to do this at once with out doing


CurrentDb.Execute "ALTER TABLE test ALTER COLUMN Last Text(25)"

for each field?

 

[dhookom]

Is there a good reason for doing this? Your fields take up as much space as is stored in the fields.

Duane
Hook'D on Access
MS Access MVP

 

[fneily]

Is your table normalized? If you're worried about storage, you may have duplicate data in your table. Sure sign it's not normalized. And inefficient.

 

[hext2003]

Yes, This is a BAD table. Not Normalized at all. I am trying to clean it up. I have split it into several tables right not. Getting Closer to getting where it should be.

I guess there is really no GOOD reason to change the size... So maybe I'll just leave it alone.