>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?

AFAIK, yes. If you also set the blocksize to 1024, you should get the optimal result.