Printing List Box

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
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.
 
Robert said:
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.
Click to expand...

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.
 
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.
 
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.
Click to expand...

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

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