List Box Not Printing

[Hfnet]

I have a form which has a text box and a list box.

The list box is populated by an SQL query, and is pulling data from an Oracle data source. I want to pass the data to a form for printing, but I have 2 problems:

1. If I choose a text box on the report, the data is shown, but it also shows the tabs and ; markers I am using to move to the next line in the list box on the form, and the data does not appear in one line, but all over the box.

2. If I choose list box on the report, the data is not shown at all.

Any ideas how I can pull the data from a form and print?

 

[dhookom]

I would never print a form. Reports are for printing.
There generally isn't a reason to place a list box on a report but it is possible.

It seems that you data/record is stored in Oracle. Use the Oracle table/query as the Record Source for your report and make sure the record is properly saved prior to printing.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[Hfnet]

It's complex. I am not printing the form, I am using a report. (typo)

The oracle query is an SQL query in the form. Basically, Oracle is queried for all order numbers relating to a customer. These order numbers are shown in a list box, and when an order number is clicked, another list box is populated with the items on that order. (in the oracle tables, every item is on its own line)

What I am after is a report that can get the details of the order that is shown on the form so that it can be printed.

 

[dhookom]

I'm not sure what your issue is. You can use a subreport to display order details.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]