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