>I'm doing a POS app and I want to use the memo field to record all the receipts, I have checked the spesification that the size of it is actually unlimited (depend on diskspace) and it seems a good place to store all the sales records.
>
>but how can I add the text to the memo field programmatically?
>
>the typical receipt is like this (40 columns):
>
>20-09-2004 Cashier: Bob
>Pizza..........1x 8.00 = 8.00
>Topping....1x 1.00 = 1.00
>--------------------------------
>Total.......................= 9.00
>
>thanks for the help.
>
>regards,
>
>Jerry

If the memo field is called lets say PocReceipt, then you could say:

REPLACE PocReceipt WITH PocReceipt + "20-09-2004 Cashier: Bob
" +CHR(13)+CHR(10)
REPLACE PocReceipt WITH PocReceipt + "Pizza..........1x 8.00 = 8.00" +CHR(13)+CHR(10)
REPLACE PocReceipt WITH PocReceipt + "Topping....1x 1.00 = 1.00" +CHR(13)+CHR(10)


etc...