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

    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

    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-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

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

    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-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,764
    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
  •