Memo in list box

  • Thread starter Thread starter -=Gillian
  • Start date Start date
G

-=Gillian

Hi,

Is there any way to put a memo field in a list box, at
least for searching purposes? (even if it cuts part of
the text off), thanks in advance.

Gill
 
Yes, you can get up to 255 characters by using one of the string functions.

Sample SQL statement as Records Source for a listbox.

SELECT Left(SomeMemo,100) as StartMemo
FROM TableName
ORDER BY Left(SomeMemo,100)
 
Back
Top