Text field size

[Kerrie Richardson]

I would like to run a make table query to create a table
in Access 2k and while creating the table limit the field
size of a text field to 100. Currently the field size
defaults to 255 (the field size of the SQL Server 7 db the
query is reading from.
I'm O.K. to create a table, I don't know how to limit the
text field size
Thanks in advance
Kerrie

 

[Van T. Dinh]

I tend not to use Make-Table Queries as they rely on JET
to decide the Table Structure for you.

You can use Make-Table Query to create the Table then open
the Table in DesignView and modify the Field Length as
required. My preferred method is to create the Table
Structure first (where I can decide the Properties of the
Table / Fields) and the use an Append Query to populate
the Table with data from the Source Table.

HTH
Van T. Dinh
MVP (Access)