Memo Field cut off in query

[Ally]

Hi,

I have a field defined as Memo in a table. When running a query, the content
of this field got cur off comparing the original field in the table. Would
anyone please let me know how to get the complete contents of Memo field
carried over in the query without the cut off? If the result of the query has
incomplete content of the memo field, the report would do the same.

Thanks,

Ally

 

[Golfinray]

More than likely, your query is not joined correctly. Make sure your tables
have primary keys and check the types of joins on each table and your
relationships.

 

[Ally]

Golfinray,

Thank you for the response. It seems that my query is working fine except
this flaw matter. Both tables have primary keys and I use the first
relationship that only includes rows where the joined fields from both tables
are equal.

I even tried to change to other two types of relationship, but still got the
incomplete the memo field for the query.

Any more tips?

Thanks a lot!

Ally

 

[Fred]

I've heard this a lot of times and the actual problem and cause were always
the same. Someone hits the "Enter" key one or many times when adding text
to a query which gets entered as line breaks, and most displays execute those
as line breaks causing much text to be knocked into "invisible" lower lines
unless you search for it with the up & down arrow keys. Putting it into a
multi-line box in a form also clarifies and solves the issue.

 

[Ally]

Fred,

Thank you. It helps!

Ally

I've heard this a lot of times and the actual problem and cause were always
the same. Someone hits the "Enter" key one or many times when adding text
to a query which gets entered as line breaks, and most displays execute those
as line breaks causing much text to be knocked into "invisible" lower lines
unless you search for it with the up & down arrow keys. Putting it into a
multi-line box in a form also clarifies and solves the issue.