I searched on-line but didn't find yet the solution for this. I am printing reports from VBA and setting application printer to the desired printer. But some reports for some reason appear as specific sometimes. This means that some letters coming out from one printer and other from different printer.
I was wondering if it is possible in VBA to
check if the report is set to default or specific.
If specific, then set to default.
At the moment the only solution I've got is after the opening line using this: reports(reportName).printer = application.printers(myPrinter).
This creates few problems, such as slowing down in a large loop and changing all the places in the application.
So ideally I am looking to do the check and if necessary set to default prior any printing once, only then enter a loop for printouts.