>>>Try open the table exclusive
>>>and apply PACK
>>>maybe there are a lot of deleted records
>>
>>No, try it. Every replace command with memo fields increas memo file size. I don't use memo fields because of that. But PACK MEMO command packing memo file. VFP doesn't replace old memo part with replace command. It deletes old memo and appends new memo at the end of file.
>
>You are wrong. VFP will put the memo back into the same place if it still fits. A lot depends on the SET BLOCKSIZE that was in effect when the table was created. If you know that your memo fields are going to go through significant additions over time you should use a bigger blocksize, this will reduce the number of times that a memo actually needs to be moved to a new space allocation inside the FPT. Read more here
http://fox.wikis.com/wc.dll?Wiki~MemoBloat.
>
>I use memo fields a lot, and I have no problem with this.
I didn't know set blocksize really... If I make it my max. memo size, my memo files won't bloated... Nice...