>Does anybody know how to force a text field to become a memo? I have a long text string that gets me: String to long to fit.

In my experience, the only way to get a memo field out of an SQL statement is to select a memo field without including it in an expression:

Source --> SQL Result Type
1. Memo --> Memo
2. Memo in a character expression -> Character
3. Any other character expression -> Character

Kind of lame, no?