Report in word using access vba

Hello

I would like to generate word report which would have plent of paragraph and around 40 -50 page of word document in that some data would be reference from access.

Now my questions is that all the word report content are tend to change in future, so I would like to have whole report as configurable and in future user can change the content of word report by changing it from access table.

So can I store them in access table? For each paragraph one row? Is this good solution to have configurable report?

Please note that I am not talking about access report here. So if things are possible in access report please do let me know as well.

Eventually word report would have graph with content as well.

Please advise.

Thanks

I myself, would do it all in an access report. You can control it all.
But you can do it in a Word merge document, but to me, this requires 2 apps and a lot of formatting, but it can work.

I believe that only thing that you would miss by doing your report in Access and then converting it to Word is images. In one of our projects a Word output was required by the customer which had images. They could have purchased Adobe professional which will convert a PDF to a Word Document and they would have had a solution but they chose to have us do it which cost them around $2000. It's a lot of work involve in creating a report in Word; especially if you haven't done it before. I'd exhaust all possibilities of using Access report before going with Word Automation.

When you say configurable report do you mean you want to store attributes like fonts in the table. If that's the case I suggest testing this with a simple Word Document. Just use DLookup and see if you can get it to work. I would guess that the attributes would have to stored as numbers as using constant names would require compilation.

Another thing you need to be aware of is that RTF large text fields are stored in an HTML format and getting those fields into a Word document is tricky. You have to write the field out to a file and the read it back into the word document as an HTML file.