Problem with memo field in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all. I'm fairly new to Access and am having a problem with a query.

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.

The strange part here is that when i make a small test query only pulling
the data from this problem field it returns the correct data. However when
its part of the larger query it only pulls the first 255 chars.

Can anyone suggest why this may be happening or give me some ideas to try?

Thanks for reading people, its apprecaited.
 
Do a search and read the previous posts on this exact question. This is a
pretty common question. Look for "truncating memo" as your search string.
 
If that doesn't answer your question. POST the SQL of the query that is not
working the way you wish. Please identify which field is the memo field.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message
 
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.
Click to expand...

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]
 
Back
Top