I have a memo field that is free-form text and we use it to keep collection call notes on customers.  When we have a new entry, it is always preceded by a carriage return.

Thanks.  This works except every few records, the entire note does not come through.  Is there any way to add to this to let Crystal Reports know to pull everything after the last carriage return?

This catches those fields where there is not carriage return.

Interesting observation.  The field cust off at the same place as the formula when it is placed on the report.  Any idea what would cause this?

I believe that you are correct in that the problem is in the data capture point.  The software is Computer Ease and they use their own ODBC driver to connect.  This is pulling from a flat file if I understand correctly.  I have an email question into them for an answer if this is a known bug.