Re: Change Field size in a query (2000)

No, field size is copied from the source fields. If you want the target fields to have a different size from the corresponding source fields, you must create an empty table with the desired field sizes first, and then use an append query instead of a make table query.
You can either create the empty table manually, or use a definition query for this, or use DAO code.

Definition queries have to be written in SQL, you can't display them in the query design grid. An example of the SQL for a definition query to create a table is