>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?
Get the first few characters of the memo field into your cursor. Use a fixed width. Example:
SELECT Field1, Field2, padr(MyMemoField, 200) as MemoField ...
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)