06/25/10

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