[AccessD] Saving string > 256 chars in field

Thanks.  The archives haven't been available for the last couple of 
hours.  Will follow this up when they are back up.

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.
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com