[AccessD] Make Table - Specifying String Field Size

dave sharpe davesharpe2 at cox.net
Wed Aug 6 20:56:43 CDT 2003


Thank You Susan

Dave


----- Original Message ----- 
From: "Susan Harkins" <harkins at iglou.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, August 06, 2003 6:32 PM
Subject: Re: [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
> >
> >
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list