Query re memo field Access 2000

[dulcie]

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!

[Steve Jorgensen]

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, pa********@hotmail.com (dulcie) wrote:

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!