Memo Field Truncating in Query

[Guest]

I've run into a field truncation problem seemingly seperate from the others
I've seen listed in the group. If I run a simple query, linking two tables
together based upon other non-memo fields, the data in my memo field is
truncated at 499 characters. I am not sorting or grouping my results in any
way. How can I retain all of the data within those memo fields in my queries?

 

[Duane Hookom]

You start by sharing your SQL view.

 

[Guest]

Below is my SQL view:

SELECT Ideabase.Name, IdeabaseIdea.CreationOrder, IdeabaseIdea.Value,
IdeabaseIdea.Category, IdeabaseIdea.Status
FROM Ideabase INNER JOIN IdeabaseIdea ON Ideabase.IdeabaseId =
IdeabaseIdea.IdeabaseId;

 

[Duane Hookom]

Are both Ideabase and IdeabaseIdea tables or are one or both queries? If you
open them individually, do you see all characters?

 

[Guest]

They are both tables, and if I open up the tables individually I see all the
characters.

 

[Duane Hookom]

Make sure that you don't have any value in the Format property of the memo
column.

 

[Guest]

There doesn't appear to be any value for Format in either the query or the
initial table.

 

[Duane Hookom]

I'm at a loss since I have never experienced or heard of this happening
without the conditions that I mentioned.