Defining Text field sizes in destination Make-Table Query

Tech-Archive recommends: Fix windows errors by optimizing your registry

when extracting fields from ODBC DB2 tables into access using Make-Table Query

howdoes one define/limit the destination text field size?

Access seems to default to 255 or 50 characters which is problematic on
large numbers of records when the field only needs to be 3 to 10 characters

Keeping blowing 2GB limit because of all the dead space.
I'm unsure of how to trim / exclude / limit during the Maketable query process
--
Jim
.