Thanks David,

I finally got it to work this morning, and your suggestion
hit it right on the nose, so thanks for your suggestion.

Have a great day.

Becky

Good Morning Rebecca...
>
>It occurs to me that you might be saying SCATTER TO (arrayname) instead of
>SCATTER TO (arrayname) MEMO.
>
>The MEMO piece ensures that the memo value is loaded into an array element
>as well as all the regular data types (character, numeric, date, etc.)
>
>The second thing that occurs to me is that you CAN edit the data record directly (memo
>field as well) on the form. You'd need to set the table's buffering mode so that VFP handles
>updates to the record. On the form, place a SAVE and an UNDO button. SAVE would execute
>a TABLEUPDATE( ) when clicked. UNDO would execute TABLEREVERT( ), restoring the original
>values of the data.
>
>As for where FoxPro saves memo data... Each record has in its memo field a pointer to the actual
>snippet (or paragraph) of text you put in there. These snippets, along with their pointers, are gathered
>by VFP into a .FPT file. If you have, for example, a CUSTOMERS.DBF table, then CUSTOMERS.FPT
>would be where you would find the various pieces of memo data (and naturally CUSTOMERS.CDX is
>the accompanying index file).
>
>You can store a bunch of text data in memo fields, and I have found them to work really well. You might
>want to ensure that you can issue a PACK MEMO command on a regular basis so that FoxPro is forced
>to rewrite the .FPT file. The .FPT file can get a little convoluted as memo data is regularly updated. New
>changes require new pointers, etc., and things get a little fragmented over time.
>
>Good luck, ~~ David B. ~~
>
>>VFP 3.0
>>
>>Hello all,
>>
>>I am using a memo field in an editbox, and need some help.
>>
>>I need to be able to pick a record on a browse screen and
>>then display the record and memo field on a form. Sounds easy
>>enough.
>>
>>I have been trying to save to memo field to an array and recover
>>it on the form, however, I am getting a data type mismatch error.
>>
>>On the browse screen, I scatter the record and then copy the memo
>>to an array....and this is where the problem lies.
>>
>>Also in the long run when I have many memo fields stored, how does
>>vfp locate these memo fields? Is this a reliable way to store
>>large paragraphs of data?
>>
>>Thanks and have a good day.
>>
>>Becky