>i'm trying to display memo fields in a listbox. i have the rowsource type as 3-SQL and the rowsource is a SQL-Select into a cursor, this part is working. unfortunately the listbox just displays 'Memo' instead of the contents of the memo field, is there any way to display the contents using this method or will i have to try a different way?
You have to use padr(left(myMemo,254),254) (or any reasonable number) or better to use another control, idea of which was discussed here recently. I'll try to find the thread info for you, if needed.
Ok, here is this thread: Forum: Visual FoxPro Category: Coding, syntax & commands Title: Re: Listing the contents of a memo field in a combobox Thread #
525262 Message #
525289 BTW, very definite subject of the thread!
If it's not broken, fix it until it is.
My Blog