Thanks Rob. I have been thinking about this option.
Ciao
>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?
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.