D-Size Report

[kjk20]

Hey all,
First time posting here.
I am new to access and was trying to get a report in D-Size.
I know that access can't go past 22" for whatever reason but is there anyway to go around that?
I thought maybe to output to word then change printer properties there but I need to make my database as user friendly as possible.
Therefore, would it be possible to export the to word then set up a macro to change printer properties automatically and print the result?



In hopes of an answer,
Mark

[June7]

You could have each page as an independent report. Then with code send the pages to printer sequentially. Problem: can't duplex and other user print jobs could print between the outputs.

I don't know how exporting report to Word would help. Still have to build the report in Access. You could export the data to a Word document or have VBA in Word that grabs data. I have done this kind of data exchange betwen Excel and Access, but not other MS apps.