Querying a memo type field

[fjt]

I have a query that selects information from a Memo data
type field. This field is used to track comments on the
particular record. Today I added another "Comment Line",
however, the query concatenates the results. Is there a
limit on "Lines" in a Memo field? The information is
being stored in the table correctly, and is visible on the
form. If I delete some "characters" from a previous line,
the last entry will increase by the number of characters I
deleted. Any suggestions?

 

[Allen Browne]

If your query performs any aggregation (e.g. GROUP BY clause or DISTINCT
predicate), or the field is formatted (Format property of field in table or
text box on form/report) only the first 255 characters from the memo field
are returned.

One way to work around that in a GROUP BY query is to specify First instead
of Group By under your memo field.

 

[John Vinson]

I have a query that selects information from a Memo data
type field. This field is used to track comments on the
particular record. Today I added another "Comment Line",
however, the query concatenates the results. Is there a
limit on "Lines" in a Memo field? The information is
being stored in the table correctly, and is visible on the
form. If I delete some "characters" from a previous line,
the last entry will increase by the number of characters I
deleted. Any suggestions?

Could you explain where you added the "Comment Line" and what's being
concatenated?

Newline characters - actually stored as a carriage return, ASCII 13,
followed by a linefeed, ASCII 10 - are just characters like "x" or "%"
as far as the memo field is concerned. There's no practical limit to
the number of lines; the number of characters in a Memo is limited to
65536 if you're entering them through a form or datasheet, and limited
only by the 2 GByte size of the database if you're filling the field
with code - so you could put a decent size encyclopedia into one!