docmd.printout - page range data type limitation?
Posted on 2009-04-24
ms access 2007
i have a report that is 42000 pages long. i am trying to use vba to print out specific ranges of pages (spreading print job across multiple printers).
when i try to print a range with a starting or ending page number over 32768, i get an error stating data type error with one of my arguments. it is happening with this line:
docmd.printout acPages, pageLow, pageHigh
both pageLow and pageHigh are declared as Long, i've also tried Variant.
i also tried:
but, that only prints out 32767 and stops (without error)
if there is a limitation with the data type in the command, is there a workaround?
if i do it manually with the print window (ctrl-p), it has no problems doing it.
what am i missing?