Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2006
    Posts
    34

    Unanswered: Report text change colour

    How do I changed the colour of the text for an entire record based on thats records type field ?

    Hope that makes sense

    James

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,469
    Provided Answers: 10
    in the format of the event of the report

    if this=that then

    Me.feildname.Properties("Forecolor") = "65280" 'this this is line green

    else

    Me.feildname.Properties("Forecolor") = "0" ' back to back

    end if

    This is the way i do it
    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
    Sep 2006
    Posts
    34
    I will give it a go many thanks
    James

  4. #4
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    There's also the sometimes useful, often overlooked "conditional formatting"

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,444
    Provided Answers: 12
    Yeah, why don't people use that?
    I included it in my AS Level Computing project and apparently it gained me an extra mark for using "high level database coding"

    I wasn't about to tell him that I simply used conditional formatting, was I?
    George
    Home | Blog

Posting Permissions

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