[AccessD] Make Table - Specifying String Field Size

I'm not aware of any syntax that allows you to set the field size in the
SELECT INTO statement. Afterward, you can use the ALTER COLUMN to change the
field size.

ALTER TABLE table
ALTER COLUMN
col Text(size)

Susan H.


> Friends
>
> With Access, when doing a "make table query"; when You include an existing
> string field, the field is "sized" in the new table to match the size of
the
> field the data is being taken from.
>
> However when You a calculate field ( such as trim(tblOne.FieldOne) & "-" &
> trim(tblOne.FieldTwo) ) access creates the the field as being 255 chars.
>
> As an optimist, and hoping that there is a "work-around" due to this; I'll
> phrase the question as "how can I specify the field size when doing
> something like this ?" .
>
> Any assistance will be appreciated.
>
> Dave
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>