Make table Set Default Text Size in Query 1

[Mentalorwot]

I am trying to create a table from a query and need to set the default size in column one to Text 20. How can i do this in the query

 

[Golom]

If its a MAKE TABLE query then the field size will be the same as the corresponding field size in the source table OR the Access-defined default field size from "Tools / Options / Tables/Queries / Default Field Sizes". If the query is a CREATE TABLE query then

CREATE TABLE myTable
(myTextField Text (20), etc.

You can also change it after you create the table with

ALTER TABLE myTable ALTER COLUMN myTextField Char(20)

 

[Mentalorwot]

Thanks

That worked a treat.