Try modifying the Tools->Options->Remote Data->Use Memo for Fields value and see it that helps. Other than that, you're stuck using remote views where you can use DBSETPROP() to specify that the field is a memo field.
>when running an SPT the text type field returns only 254 characters, but when retrieving data using a remote view complete data is returned.
>
>ANY IDEA WHY??
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05