"Memo" fields in access

I am currently working on a content management system to store articles, tutorials and other things... this problem happened to me once before but I've forgotten what I did to work around the problem.

when I run a query to retrieve a the "content" field from my "Articles" table, the result has only the first 255 characters of the field's content.

the only thing to note about the SQL statement is that I group the records and count the number of related record on another table, i.e.:
<font face="Courier New">SELECT Articles.article, Articles.content, Count(Feedback.feedback) AS n
FROM Articles LEFT JOIN Feedback ON Feedback.article = Articles.article
WHERE (article = [whatever])
GROUP BY Articles.article, Articles.content</font id="Courier New">

anybody know why? how do I work around that?

Are you reading the value from the recordset more than once? Like rs("article") and somewhere later rs("article")?

I've read you can use GetChunk to read the memo field but it seems like there should be something better...

no. I only read it once...
Can you tell me how I can use "GetChunk"? (never heard of that)
Thanks

<blockquote id="quote"><font size="1" face="geneva, verdana, arial" id="quote">quote:<hr height="1" noshade id="quote">The first thing to remember is always put the long text field last in
your SQL statement. There is a bug somewhere (ADO or SQL Server) which
causes data to be truncated otherwise.<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">That kinda sums it up.

The code in that example really sucks.

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder

thanks guys!!!!!
btw.: that website is wicked......