Access: printing multiple copies of report

Home
Up
Software
Articles

Access: printing multiple copies of the report

Recently, I had a problem in Microsoft Access – one particular report always needs to be printed in 2 copies. Searching on the web produced some results (including from Microsoft’s own website, KB 200548), however closer to workarounds than to true solution – they involved opening the report in preview mode first.

I think I have found more elegant solution:

  1. open the report in design mode; let’s say it’s name is Report1
  2. in VBA/Immediate window, type:
    reports!report1.printer.copies=2
  3. save the report

Home

This site was last updated 12/31/12