If you could live with a 254 Char memo, you could have a seperate table with a PK field and a Character field. This way you always store it back to the same physical location and only use space where a note exists. With a bit more work, you could expand it to have more space.
I used this technique MANY years ago (Pre FP 1.0) and it worked great.
>Hi All
>
>If I want to allow a note to be captured into a memo field can I avoid the memo bloat by always saving a fixed size note i.e. SUBSTR( lcMyText, 1, 1024 ) for example?
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'
