Lexmark s305 printer issues

[PaulO]

I have a right 'funny' going on ...

I have a database with many standard command buttons running reports e.g.

Private Sub Command244_Click()
On Error GoTo Err_Command244_Click

Dim stDocName As String

stDocName = "Portrait Pedigree4"
DoCmd.OpenReport stDocName, acPreview

Exit_Command244_Click:
Exit Sub

Err_Command244_Click:
MsgBox Err.Description
Resume Exit_Command244_Click

End Sub

One report screen has 11 such report commands. Only four of which work ... all the others give the message "OPEN REPORT ACTION WAS CANCELLED"

We only get this error with the Lexmark s305 printer (all-in-one). With other printers ALL the print command buttons work. I downloaded the latest printer software updates and the problem persisted.

I dug into the report design and initially got this message "There was a problem retrieving printer information for this object. The object may have been sent to a printer that is unavailable"

I then went into Page Setup and, to make the report print I had to re-point the report away from the default printer (yes, the Lexmark) and then point specifically at the same Lexmark and hey presto the report printed!

Now, I don't want to recode the Page Setup on each report to a specific printer, I always want to point at the Default printer, so has anyone got any idea why this printer is so choosey about what it prints?

 

[PaulO]

Update:

Lexmark appear to accept that this is a problem at their end ... seemingly they cannot get their printer to act/pickup as the default printer for all reports!?

Anyone else experienced anything similar with Lexmark or any other Manufacturers?

Another thing I didn't know ... apparently if you leave your default printer as "Microsoft XPS Document Writer" then all the Access reports print out fine ... even to the Lexmark mentioned above!