[AccessD] Saving string > 256 chars in field

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.