Kathleen,
I tried the following with the results in brackets

Debug.Print tdfTemp.Fields("Log Type").Name
(Log Type)

Debug.Print tdfTemp.Fields("Log Type").Size
(3)

Debug.Print tdfTemp.Fields("Log Type").Type
(10)

In the access database, the field is set as type TEXT, with a size of 3.
I've continued to look for answers but the only thing I've come across was
for Visual FoxPro.

Thanks

James



"Kathleen Joeris" <kjoeris@noemailplease.com> wrote in message
news:38ca625a@news.devx.com...
> James,
>
> What is the type of the "Log Type" field?
>
> What happens if you say (in the first example)
>
> Debug.print tdfTemp.Fields("Log Type").Name
> Debug.print tdfTemp.Fields("Log Type").Size
>
> --
> Kathleen
> (MS-MVP)
> Reply in the newsgroup so everyone can benefit
> --
>
> James E <JEdwards@theclancygroup.co.uk> wrote in message
> news:38c8cb9e@news.devx.com...
> > Kathleen,
> > I've tried the following two methods:
> >
> > Attempt 1: (produces error code 3219 - Invalid Operation)
> >
> > Set tdfTemp = MyDatabase.TableDefs("Appointments")
> > tdfTemp.Fields("Log Type").Size = 10
> > Set tdfTemp = Nothing
> >
> >
> > Attempt 2: (Which returned error 3293 - Syntax error in ALTER TABLE
> > statement)
> >
> > MyDatabase.Execute "ALTER TABLE [Appointments] ALTER
[Log
> > Type] C(10);"
> >
> > Am i getting it totally wrong? How should I be doing it?
> >
> > James E.
> >
> >
> >
> > "Kathleen Joeris" <kjoeris@noemailplease.com> wrote in message
> > news:38c85690@news.devx.com...
> > > James,
> > >
> > > What did you do to try this and what happened?
> > >
> > > Basically, get a reference to the tabledef
> > > Get a reference to the field
> > > Change the size
> > >
> > > --
> > > Kathleen
> > > (MS-MVP)
> > > Reply in the newsgroup so everyone can benefit
> > > --
> > >
> > > James E <JEdwards@theclancygroup.co.uk> wrote in message
> > > news:38c62cff$1@news.devx.com...
> > > > In my Access 97 Database which I am accessing through my VB6
program,
> I
> > > have
> > > > a field which is of type text, with a size of 3. I want to increase
> this
> > > to
> > > > 10, without having to create a new field of this size and copying
all
> > the
> > > > data into it. I've looked through the MSDN but couldn't find
anything
> to
> > > > help.
> > > > Can anyone help me?
> > > >
> > > > Cheers
> > > >
> > > > James E
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>