Access form with SQL Server Append Query

[David]

Hello! We are using Access 2000, SQL Server 2000. We are using a
simple append query to append data from an unbound form field to an
SQL Server linked table. The field in Access is a memo field, and in
SQL Server it is an nText field. However, some of the text gets
garbled at the end of long entries (approx. 510 characters.) An
example of this follows:

The quick brown fox jumps over the lazy dog. The qu ī̌դ ᴠ왠ໟĀ ƒ
Ĭ̈໹

Is this a product of the linkage? Should I use a different SQL
Server
field? Any other recommendations? Thanks!