Querying a memo type field

  • Thread starter Thread starter fjt
  • Start date Start date
F

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?
 
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.
 
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?
Click to expand...

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