Ask a Question related to Microsoft Access, Design and Development.
Memo in list box
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.
Hi all, i'd like to know if there is some way to detect whether a field is of type MEMO (i'm using MS Access) so to behave accordingly placing a...
hi .. i am using memo field in a field which has to take long data. when i do the insert its now givng me error: Error Type: Microsoft OLE DB...
> is there any appreciable difference between using a field If it's just TEXT, use Memo (or better yet, store the RTF file in the file system). ...
Here is what I am trying to do filecont = objRS("contents") filecont = replace(filecont,vbLF,",") if i use the objRS instead of the filecont...
Sounds like Extend mode. Next time this happens, see if EXT appears in the status bar. You've probably bumped F8. Esc is supposed to cancel...
John Spencer (MVP) #2
Re: Memo in list box
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
ORDER BY Left(SomeMemo,100)
> 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.
> GillJohn Spencer (MVP) Guest