Set Field Size with Make Table Query

  • Thread starter Thread starter Randal
  • Start date Start date
R

Randal

Is it possible to set the field size with a make table query. When I
generate a text field with a make table query that field defaults to Field
Size = 255.

Thanks,
Randal
 
You will need a data definition query to set field sizes. What you could
consider is to create a table using the structure you want as a template.
The instead of doing a MakeTable, simply do a Delete followed by an Append.
 
Is it possible to set the field size with a make table query.
Click to expand...

No.

That said... a couple of things to consider. Access Text fields
truncate trailing blanks, so a three-letter value takes up three
characters, whether it's in a Text(3) or a Text(255) field. It may not
matter much!

More importantly, in my experience MakeTable queries are VERY rarely
really necessary. You can use a Select Query as the recordsource for a
form or a report; you can base another query on a query; you can
import and export queries. Are you certain you actually need a Table?

John W. Vinson[MVP]
 
Back
Top