default text field size

[Kerrie]

I am running a make table query which defaults a fields
data type to text and the field size to 255. I would like
the field size to default to 75. Any suggestions?

NB: I want the field size to be set to 75 as the make
table query is running, rather than manually changing the
field size in the design view after the table has been
created.

 

[Van T. Dinh]

Not AFAIK. Using Make-Table Queries relies too much on
Access to work out the correct type.

Personally, I always create the Table Structure as I want
first and then use Append Queries to append Records rather
than the Make-Table Queries.

HTH
Van T. Dinh
MVP (Access)