Re: Word truncates Memo field when using Automation from Access

Laurie Almoslino <laurie@xxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:928Ge.8$0B5.2212@xxxxxxxxxxxxxxx:

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

No, that has nothing to do with it.

I've encountered the same problem within Access, but triggered by
concatenating memo fields.

I think it's an inherent flaw in DAO and the inner workings of
Access.

The only workaround I found was to do the concatenation in the Word
file, which resulted in extra spaces, but that isn't a problem
because the destination is a web page, where HTML treats any white
space the same (one space is rendered as one space, two spaces are
rendered as one space, and so forth).

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
.

Relevant Pages

  • Re: Saved query doesnt select all info in Memo field.
    ... error message and implemented some property that the error message ... You cannot sort/group on memo fields. ... Access truncate the fields at 255 characters so that it can ...
    (microsoft.public.access.queries)
  • 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: Blog Comment Count
    ... Memo fields always get truncated to 255 characters when grouped. ... using First vice Grouping. ... There are also some other conditions that will truncate memo fields - I believe ...
    (microsoft.public.access.queries)
  • Re: Need Help with Memo Field
    ... Also be aware of some other problems you can have with memo fields. ... Crosstab queries, Summary queries, Union queries, and Queries that use ... Also, if you have specified a format in the field's Format property, I ... that will truncate the data that is displayed. ...
    (microsoft.public.access.forms)