When you say "list", I hear 1-to-many relationship. Should you not have a
related table with a single record per paper rather than a text/memo field
containing a textual list of papers?
On 9 Jan 2005 13:33:32 -0800,
pasirochma@hotmail.com (dulcie) wrote:
[color=blue]
>I'm trying to put the contents of a college library onto an Access db
>- problem is the long list of research papers going into one
>particular cell of one particular field. I can change this to a memo
>field rather than a text field so that it can take a lot of
>characters, but then students can't perform a search for these papers
>because the search - or filter - will only find the first 250
>characters in the memo field. Anyone know how I can get it search
>the whole of the memo field? I'm not an Access expert!
>
>Cheers![/color]
Query re memo field Access 2000 
