I run a report of nearly 10 pages in Ms.Access, included in with various
conditions. When I export text to Ms.Word, the text is not justified but is
left aligned. Is there any possibility of getting text aligned at export.
Any Code that could substitute is highly appreciated.

No, you cannot format the report going from Access to Word.
--
Dave Hargis, Microsoft Access MVP


"Repath Athyala" wrote:

> I run a report of nearly 10 pages in Ms.Access, included in with various
> conditions. When I export text to Ms.Word, the text is not justified but is
> left aligned. Is there any possibility of getting text aligned at export.
> Any Code that could substitute is highly appreciated.

As Klatuu said, no. Access exports as an .RTF file which can be used as a
Word document, but not with all the fancy formatting bells and whistles.

I have seem people do a work-around by doing a mail merge with an existing
Word documents. That could get rather involved with a 10-page report though.

If the users just need to see the report, and not modify it, then you could
export/print it as a PDF file. Access 2007 has a free download for creating
PDF's. With older versions of Access, there are some very inexpensive PDF
tools like PDF995 available.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Repath Athyala" wrote:

> I run a report of nearly 10 pages in Ms.Access, included in with various
> conditions. When I export text to Ms.Word, the text is not justified but is
> left aligned. Is there any possibility of getting text aligned at export.
> Any Code that could substitute is highly appreciated.