default text field size

K

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.
 
V

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text Field Size - Access 2007 2
Changing multiple field sizes to same size 6
can't change the data type or field size 3
Database Size Problem 5
Field Default Value 0
Memo vs. Text 255 8
Trying to add Long Integer field 1
Can't change data type 3

Top