[AccessD] Saving string > 256 chars in field

Thanks Francisco.

It is actually Access XP and it is an ADP.  I do have the service packs 
installed.

I changed the field to ntext and it works!

Thanks.

At 6/07/2005, you wrote:
>Access 2000? I seem to remember you need to have SR1a installed...
>Additionally because you're trying to make it a bound form, I think I
>converted the field from nvarchar to ntext. The Front End will then
>handle it correctly for what it's worth moving up to A2003 makes this
>whole point moot.
>
>
>
>On 7/5/05, David Emerson <newsgrps at dalyn.co.nz> wrote:
> > I have tried the archives but cant find anything.  Francisco - can you
> > remember what the subject was?
> >
> > David
> >
> > At 28/06/2005, you wrote:
> > >This is a known issue. If you search the archives for Francisco Tapia name
> > >you might find the right answer.
> > >
> > >But if I remember correctly, you have to do your final select with that
> > >field cast as a Text, so Access (trying to be too smart) will not truncate
> > >what it considers a text field and then assumes it is a memo field.
> > >
> > >David
> > >
> > >-----Original Message-----
> > >From: accessd-bounces at databaseadvisors.com
> > >[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of David Emerson
> > >Sent: Monday, June 27, 2005 7:08 PM
> > >To: Access Developers discussion and problem solving
> > >Subject: RE: [AccessD] Saving string > 256 chars in field
> > >
> > >
> > >Yes - Access XP adp, SQL2000.
> > >
> > >David
> > >
> > >At 28/06/2005, you wrote:
> > > >Are you working in an .adp?
> > > >
> > > >Susan H.
> > > >
> > > >Yes it is bound, however the field is a nvarchar(1000).  I can manually
> > >type
> > > >in more than 256 characters and they save ok.  It is just when I use VB.
> > >
>--
>-Francisco
>http://pcthis.blogspot.com |PC news with out the jargon!
>http://sqlthis.blogspot.com | Tsql and More...