Query with Memo field

H

Homer

I'm trying to run a query which includes a table with a Memo field.

Query won't even run but giving me this error:

"The field is too small to accept the amount of data you attemted to add.
Try inserting or pasting less data"

If I remove the memo field from the query it works fine.

How can I make it work? I can't change the memo field to text as then it's
too short.

Access 2002
Thanks
 
D

David Lloyd

The following KB article deals with a similar issue to the one you are
seeing.

http://support.microsoft.com/default.aspx?scid=kb;en-us;896950

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I'm trying to run a query which includes a table with a Memo field.

Query won't even run but giving me this error:

"The field is too small to accept the amount of data you attemted to add.
Try inserting or pasting less data"

If I remove the memo field from the query it works fine.

How can I make it work? I can't change the memo field to text as then it's
too short.

Access 2002
Thanks
 

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

disctinct query memo field 3
Query field size quandry 2
Dates in a memo field 3
Can I use totals on one field and still have a memo field? 4
Memo fields in a query 4
How can I convert text field to memo field in a query 10
how can I specify text criteria when querying a memo field 1
Make Table Query Truncating Memo Field at 255 Characters 2

Top