Export Access fields to Word

[Peter]

We have to export a number of columns from Access 97 to
Word.

However, those columns are pretty long in length so that
we are not able to manage to display them properly in
Word. Is it possible for us to add CRLF to those
fields ? OR Should I do the manipulation in Word ?

I have attempted to export to Excel but cannot work out
how to paste to Word.

Your advice is appreciated.

 

[Arvin Meyer]

Using a query, you can alias a column to add a CrLf in the querygrid like
this:

NewColumn: OldColumn & Chr(13) & Chr(10)

Further parsing can be done using the Left, Mid, and Len functions to divide
the old column.:

Left(OldColumn, 30) & Chr(13) & Chr(10) & Mid(OldColumn, 31, Len(OldColumn))
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access