Re: Word truncates Memo field when using Automation from Access

You are absolutely right - I was using "distinct" in the query, and
didn't know that causes Memo fields to truncate. This may also solve
some other long-standing mysteries!

Thank you very much!



*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Using CStr on a Memo field
    ... Grouping or sorting on it in a report ... Using DISTINCT in a query ... none of those that I know of will truncate the field. ... I've only ever used Leftto truncate memo fields for those ...
    (comp.databases.ms-access)
  • Re: Data Entry Mode
    ... the formatting so maybe I can change something to help my situation. ... > Totals Query for some legitimate purpose, and you need to include a Memo ... >> All my memo fields for data entry but may be in a query used to supply other ... >> truncate. ...
    (microsoft.public.access.forms)
  • Re: Make Table query Memo field
    ... > Memo fields are troublesome at times. ... > table in advance and change your make-table query to an append query. ... >> I Make the Table the field appear truncated to 255 characters. ... >> are kept and not truncate to 255. ...
    (microsoft.public.access.queries)
  • Increasing the value in a query (max 2000)
    ... Is there a way to increase the maximum result value in a query so it will not ... I searched through the SMS help but did not find anything about it. ... Prev by Date: ...
    (microsoft.public.sms.admin)
  • RE: Make Table query Memo field
    ... Memo fields are troublesome at times. ... table in advance and change your make-table query to an append query. ... > I Make the Table the field appear truncated to 255 characters. ... > are kept and not truncate to 255. ...
    (microsoft.public.access.queries)