[AccessD] Fwd: Saving string > 256 chars in field

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...