Re: Problem with memo field in query

From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 30 Mar 2006 23:09:37 -0700

On Thu, 30 Mar 2006 06:40:05 -0800, Gav
<Gav@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

The query pulls data from multiple fields. One of these fields is of type
memo. In this field are 500 chars (approx). For some reason when i run the
query it pulls only the first 255 chars from the field and omits the rest.

This usually happens when you Sort or Group by the memo field. Access
won't attempt to sort records on the basis of a memo field (which,
after all, could be over a gigabyte in size) so it truncates it.

John W. Vinson[MVP]
.

Prev by Date: Re: I want to select either specific records or all in same query
Next by Date: Re: help with getting to end report
Previous by thread: Re: Problem with memo field in query
Next by thread: If statement
Index(es):
- Date
- Thread

Relevant Pages

Re: Problems saving MemoText (over 255 chars) into ACCESS2000
... >If the text exceeds 255 chars, the saving will get errors. ... storing text> 255 characters in the memo fields. ...
(borland.public.delphi.database.ado)
Problems saving MemoText (over 255 chars) into ACCESS2000
... I am facing the problem of saving the memo text into an Access table. ... How could I save text into the memo field when text is over 255 chars? ...
(borland.public.delphi.database.ado)
Re: Problem with memo field in query
... POST the SQL of the query that is not ... Look for "truncating memo" as your search string. ... The query pulls data from multiple fields. ... In this field are 500 chars. ...
(microsoft.public.access.queries)