Printing List Box

[Robert]

How can I print the entire contents of a list box on a form?

 

[Rick B]

Forms are not really designed for printing.

Build a report and print that. For the report source, you could use the
same as your list box source.

Rick B

 

[Robert]

This will not do. The list box has a multi select so users can select and
delete records. A report will not allow a multi select list box.

 

[Robert]

This will not do. The list box is a multi select so users can select and
delete records. A report list box will not allow a multi select list box.

 

[Rick Brandt]

This will not do. The list box is a multi select so users can select
and delete records. A report list box will not allow a multi select
list box.

But you can give them a form with the ListBox on it so they can make their
selections and still have a separate report that you print.

 

[Robert]

Yes I can do that but that would require showing the user a form for
selection and then showing them a report of the same content and having them
click a print button on the report. Rather complex for a simple user. I can
also dump the list box to a table or text file but I do not know of a way to
print them automatically.

 

[Tim Ferguson]

that would require showing the user a form for
selection and then showing them a report of the same content and
having them click a print button on the report.

No: you can do a DoCmd.OpenReport with the acViewNormal parameter that
sends it straight to the printer.

Tim F

 

[Robert]

Thanks Tim. this works fine. I had forgotten that ACViewNormal went
straight to the printer.