>Even if field names are the same, you cannot append a character field (from one table) to another table with a memo field. Given.the example:
>
>Append From SomeTable Field LongString
>
>If LongString is type "C" in the source, and Type "M" in the currently open table, no data is appended.


You have 2 data types -- that a no-no. (s) Here is some code I use to append to a Memo field:

replace OrderItems.mInvenProp with lcTmp additive

Hope it helps (HTH)

Tom