Publishing into Word - losing format

[sarcasmic]

Hello,

I've created a database that has all the intermation that I need at the moment, and I've created a report that pulls all that information together the way I'd like...but whenever I publish the file into Microsoft Word, it loses the pictures and borders that are in the report, and just takes the text over in rich text format.

Is it possible to generate a word file that looks exactly like the report that I've generated, with pictures and everything?

I was able to "print" the file in the Microsoft Document Image format, and convert that to .pdf to distribute, but I'd like my users to be able to type in their response information in the blank fields provided in the report. So I want to be able to lock all the information that I am sending them, and only allow them to type in the blank fields.

Anybody have any ideas? Thanks!

 

[MyBoo]

One option:

Create a Word Document, formated to look the same as you Access report and feed your data to this document via VBA. Look up CreateObject in Access.

 

[id3als]

This can also be done in word using a mail merge function.

If the data you require in the word doc is stored in a table you can set up the word doc in the required format and use text boxes that are linked to the table. (via ODBC or something) No code required.

When this connection to word is set up it is much like building a form, you just insert a text box where it is required & when you preview the doc it is populated.

If there are many records in the table this will produce 1 page per record.

hope this helps