Ask a Question related to Microsoft Access, Design and Development.
-
-=Gillian #1
Memo in list box
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
-=Gillian Guest
-
Detecting MEMO field
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... -
memo -field-urgent
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... -
Memo Field vs. OLE Obj
> 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). ... -
Working with a Memo Field
Here is what I am trying to do filecont = objRS("contents") filecont = replace(filecont,vbLF,",") if i use the objRS instead of the filecont... -
Memo fields
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
FROM TableName
ORDER BY Left(SomeMemo,100)
-=Gillian wrote:>
> 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.
>
> GillJohn Spencer (MVP) Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
