How to retrieve only a portion of a Memo Field

[DakotaChick]

I need to retrieve just the first few lines of a memo field. I'm not really sure how to go about doing this. Any help would be appreciated.

Oh, my db is Access 2000 format.

[dudeshouse]

I think you'll need to decide how many characters you're going to read from it, rather than the number of lines, unless you consider "number of lines" to mean number of line-breaks, in which case you could filter by line breaks in the memo field by looking for Chr(10).
HTH.

[glenngv]

Use the Mid (http://devguru.com/technologies/vbscript/13951.asp) function.