The memo will be truncated if you use a source query that involves any
aggregation (e.g. a GROUP BY clause or DISTINCT predicate in a SQL
statement), or formatting (e.g. UCase(), or something in the Format property
of the memo field in the table or the Format property of the text box on a
form).
In a Totals query, you may be able to avoid the issue by using First(MyMemo)
instead of grouping by the memo field.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Rose" <MA6954@AOL.COM> wrote in message
news:e84df747.0312030900.3a5a5b9@posting.google.co m...[color=blue]
> I have an access 2000 database. In it I have a table OPEN Items which
> has a field Issue that is setup as a MEMO field. I am trying to
> append information from another table with the same setup, but it does
> not bring in all of my memo field - it cuts off the data. I have
> other queries setup to do the same thing from different tables and
> they work fine. I cannot see anything different in my tables or
> queries. Anyone have any ideas of what I might be doing wrong.[/color]
