Memo fields truncated

Thanks for the hint.
But I've not set any table-level format instruction for the Memo fields.
The fields appear all right when merged, say, from a query, with a Word 2000
document.
But when displayed in a report (or exported to Word 2000 from a report),
they are truncated after the first 255 characters, no matter what.
Obviously I am missing something here!?

Paul Dussault

> Remove any format instruction in the Table properties for the Memo Field.
>
> Hth
>
> Hugh
>
>
> Paul Dussault wrote:
>
> > Hi All,
> >
> > How can I export an Access 2000 report to a Word 2000 document without
the
> > Memo fields it contains being truncated to 255 characters?
> > Is there a 255 character limit for the text fields of an Access 2000
report?
> >
> > Thanks,
> >
> > Paul Dussault
>
>
>

In case this can help someone:

The trouble wasn't with the reports or with the merge fields, but with the
UNION queries on which the reports were based (I guess my problem
description was missing a key point...).
Union queries seem not to concatenate Memo fields correctly and truncate
them.
I replaced each of the Union queries by a table populated by a set of Append
queries and a few lines of VBA code.
All is working great.

Beware of Union Queries with Memo fields.

Paul Dussault

Interesting. I never knew this.

Thanks, Tony
----
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
VolStar http://www.volstar.com Manage hundreds or
thousands of volunteers for special events.

>Paul Dussault
>

Also beware of grouping queries with memo fields. They will also get
truncated. (this is A2K)

(Followups set)

--
John