Re: Word truncates Memo field when using Automation from Access

Hum, this is just a guess, but it probably has to do with your query.
I have found that SELECT DISTINCT converts Memo fields to text fields,
hence truncating to 255 characters. Any time a Group By is used in a
query the Memo fields are converted to text fields.... I hope you find
your problem.

.

Relevant Pages

  • Re: Merging content from access
    ... that could well be the case - I guess you'd see if you ran the same query in Access. ... I have an expression that calls a vba function to collate records from all of the notes resulting in a long field. ... Historically, there have been character-count limit problems when Word gets data from Access memo fields (e.g. the limit for ODBC connections was increased many years ago, I haven't researched the Access limitations" problem anything like as much as the equivalent problem in Excel. ... The other field-based technique requires you to have a "parent" table as the mail merge data source and a child table inserted using a DATABASE field. ...
    (microsoft.public.word.docmanagement)
  • Re: Memo field truncated in report if report contains sorting and grouping
    ... The original query included calculations as ... queries, one for all text and memo fields, one for all ... together in final query to be used in report. ... >sorting on the field, ...
    (microsoft.public.access.reports)
  • Re: Data Entry Mode
    ... All my memo fields for data entry but may be in a query used to supply other ... I have more which right now are truncating down to 255 characters after I ...
    (microsoft.public.access.forms)
  • Re: Problems querying memo fields
    ... PH> the application query Memo fields and they work fine within Access. ... PH> and an ODBC DSN connection, all of the other queries seem to work ... PH> Memo fields through an ODBC DSN, or that not all of the Memo field ...
    (microsoft.public.data.odbc)
  • Re: Truncated memo fields from queries within queries
    ... query, and got length values beyond 255, just as you said. ... one of the memo fields with a length of 400 or more, then hit the End key on ... > Allen Browne - Microsoft MVP. ... >> The Jet version is 4.0.6508.0. ...
    (microsoft.public.access.queries)