Help Displaying Fox Pro Memo Field

[M_S_Jones]

Hello,

I'm modifying a report that retrieves data from a FoxPro-based system. One of the fields returned is a memo type field. Currently the report just returns the whole field, which could consist up to seven lines. Up until now this hasn't been an issue, but recently some records have been added that use more lines of the memo field than there is room for in the report (which only returns up to four rows). These lines are short in length, and so don't warrent whole lines to themselves, it would be good to fit two lines to the row in the report, so that the full seven could fit on one page. However, I can't find a way of returning individual lines, other than using ALINES() to put the lines into an array, which I can't use in the report. I find that if I take a substring of the memo that is long enough, I get the first row only. Is there any way to easily specify each of the other rows?

Thanks,

Matthew

 

[M_S_Jones]

I have since received assistance from another source, and this issue is now resolved. In case anybody else encounters this situation, individual lines can be specified from a memo field by using the MLINE() function with the following syntax:

MLINE(MemoName, LineNo)

Matthew