[AccessD] Error Message: The field is to small to accept the amount of data you tried to add. Try inserting or pasting less data

I am getting the above message in an A97 FE connecting to a SQL Server BE.
I do not get the error message when using A2K FE (both version of app have
the same code.)


This I found the record that is causing the problem along with the field.
Once I remove the field from my pass-through query in A97 the results are
returned.  If I leave the problem field in the query I get the message
above.


The data in the field is:



12/2/02-TR rejected review needs documents and completed Master Initial
Account Review Checklist.  E-mail sent to Mike Herberger to notify him.
BJQ.  12/19/02-AM review done date removed due to TR rejection.  BJQ. Sent
IR checklist to Barbara. 1/8/03 MH


The field on the BE is a nvarchar (255).  Any ideas or helpful suggestions
would be nice.

TIA
-Jeff
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030630/33f6f555/attachment.html>