[AccessD] Reader problem: memo field complains when entering Wordtext

...it could be that your reader is using a query with the Unique Values 
property set to yes and a memo field included ...if so there is, iirc, an MS 
KB on the bug somewhere ...the Unique Values results in a comparison of the 
memo fields using text boxes ...you get no error, just the first 255 
characters ...basically you have to run one query without the memo field and 
then use it as a source for another query with the memo field from the table 
itself included.

William Hindman

----- Original Message ----- 
From: "Susan Harkins" <ssharkins at setel.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Wednesday, April 11, 2007 11:18 AM
Subject: [AccessD] Reader problem: memo field complains when entering 
Wordtext


>A reader is trying to cut and paste text from a Word document into an 
>Access
> memo field. When the text is over 255 characters, the Memo field rejects 
> the
> entry. I ran a quick test for myself and did _not_ run into this problem.
> I've checked microsoft's support sites and not found anything.
>
> Any help? The best I can come up with is a corrupted table.
>
> Susan H.
>
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>