>I'm trying to re-structure a table that has a 254-byte notes field and a memo comments field. I need to combine these two into one memo field, IE:
>
>lmNewMemo = lcOldCharField + Chr(13)+ Chr(10) + lmOldMemoField
>
>The "lmNewMemo" field contains just the old memo field.
>
>Any suggestions?
>
>Thanks,
>
>Harry

Harry,
Try :
replace lmNewMemo with lcOldCharField + Chr(13)+ Chr(10) + lmOldMemoField

Cetin