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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MEMO Field cut off on Form 3
Arranging text in a memo field 2
Memo field in a combo box 1
Auto Print Settings for Form 3
Memo fields in a combo box 2
Memo Box Jumping 1
Memo Field 3
Alternative to Access 2007 Memo Fields 14

Back
Top