Problem for report printing's color

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • colintis
    Contributor
    • Mar 2010
    • 255

    Problem for report printing's color

    I have a simple database to print reports in the company, but the default setting for the printer seems different. The printer's default setting will print all pages in black and white, even the reports don't have any colors as well.

    When a print button is clicked, the procedure automatically changed to print in color; because a login is required if the quality is set to color in the company printer. I have no idea why only this database will do this itself. The VBA code for the button is as follows:
    Code:
    Private Sub cmdPrint_Click()
    On Error GoTo Err_cmdPrint_Click
    
        Dim stDocName As String
    
        If frameStyle.Value = 1 Then
        
            stDocName = "Washout1"
            
        ElseIf frameStyle.Value = 2 Then
        
            stDocName = "Washout"
        
        End If
        
        DoCmd.OpenReport stDocName, acViewNormal
    
    Exit_cmdPrint_Click:
        Exit Sub
    
    Err_cmdPrint_Click:
        MsgBox Err.Description
        Resume Exit_cmdPrint_Click
        
    End Sub
  • colintis
    Contributor
    • Mar 2010
    • 255

    #2
    I had made a bit of work around to print the report in a semi-auto way: open report -> open print dialog -> print -> close report.
    Code:
        DoCmd.OpenReport stDocName, acViewPreview
        DoCmd.RunCommand acCmdPrint
        DoCmd.Close acReport, stDocName
    From the print dialog, I found the database itself changes the setting print quality from "Black and White" to "Colour", this doesn't happen to any other databases I worked on, only particularly this one.

    Comment

    Working...