Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7

    Red face Unanswered: Change Background color in report

    I have this Code in the Detail_Format

    If IsNull(Me.PColour) Or Me.PColour <> "" Then
    Me.TagColour.Properties("BackColor") = Me.PColour
    Me.TagColour.Properties("forecolor") = Me.PColour

    Me.Mes1.Caption = ""
    Else
    Me.TagColour.Properties("BackColor") = vbWhite
    Me.TagColour.Properties("forecolor") = Me.PColour

    Me.Mes1.Caption = "No Tag"
    End If

    I can see the on screen OK
    but when I print I don't see the Background colour
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    I fix it it was a setting in the printer driver
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Glad you got it resolved, MYLE! This kind of thing is almost always a Printer-related rather than an Access problem. Amazingly, the last time I saw this exact problem posted, after much back and forth, I thought to ask the OP if he was using a color printer, and the answer, of course was "No!" OP went further to say that he thought it would print in color if "Access told it to!"

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •