>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.
>
>Tried padding the string to 260 bytes to overflow a text field, but that didn't work.
>
>Any ideas?
>
>+++ Rick ---
If you're using MS SQL Server, have you tried the CONVERT() SQL function?
Something like, "SELECT CONVERT(Text, FieldA) ...".
I'm sure other SQL DBMSes have similar functions. HTH!
alistair israel
Distressed DBA, Sleepy SysAd, Weary WebMaster (aka Senior Software Engineer)
aisrael@poboxes.com
Makati City, Philippines