I sent this message to couple other forums and didn't get any answer, hope to get some help here.

Have a report with a listbox based on a query.
When send it to Word (Publish with Word), the listBox
doesn't appear.
Is there a way to pass the query, or better to say, the listBox to Word???

:confused:

TIA

Have a report with a listbox based on a query.
When send it to Word (Publish with Word), the listBox
doesn't appear.
Is there a way to pass the query, or better to say, the listBox to Word???


I think the answer lies more in your method...

Why are you trying to pass a database form object to a Word document?

Thanks for Replying!

Some users wants to mail the report as rtf or to send it to Word and Edit
the report.

Editing the Report in Word sound a bit flaky to me. You will then have a report initially from a Database that contains information not held within the database :confused: :confused:

On the original problem why not pring to Acrobat Distiller and create a pdf. This is then literally a clone of the Access Report

len B

Hi len

The report is produced as a document to the customer. The user works
in the field with farmers and makes a fertilizing plan. Then he
prints it, or work at home and send it to the cust with E-mail.
In both cases he needs to add details that we don't keep in the DB.

About the Acrobat, not many customers can open it.
Snapshot is a grate way to mail with all data (not edit ,of course) but the
problem is the same.

Could you convert the listbox to a sub-report? This should export.

In fact, the Listbox was in a subreport and that was the same.
But thinking again, you apparently mean - a report without listbox?
That might be the solution.

Thanks!!! :) :)

Why use a listbox at all since reports are not user interactive?

That is the best way (I know) to display a crosstab query.

In fact, the Listbox was in a subreport and that was the same.
But thinking again, you apparently mean - a report without listbox?
That might be the solution.

Thanks!!! :) :)


Yes - Get rid of the list box. Let me know if it works.

That is the best way (I know) to display a crosstab query.
Is your crosstab dynamic?

Yes, it is.

Ken
I build a report based on the crosstab query that runs nicely but
when use it as subreport, with the crosstab as record source - no data displayed, and without record source - only one row is displayed without
Row Heading.