color coding values

Discussion in 'Access Forms Coding' started by fishqqq@hotmail.com, Jan 4, 2013.

  1. Guest

    I have a form which tracks budget numbers and i'd like to be able to
    color code the current results.

    [text52] = the total budget (text field)

    [text54] = (=[Budget]-[Text48]) the current amount of budget used
    (text field) - this field is set with a GREEN font

    [red] = is a number field with the field size set to "double" and the
    format set to percent. the user sets the value in this field, ie 25%,
    and as soon as there is =<[red] left before going over budget than the
    value in [text54] will be show in RED font.

    [yellow] = is a number field with the field size set to "double" and
    the format set to percent. the user sets the value in this field, ie
    50%, and as soon as there is =<[yellow] left before going over budget
    than the value in [text54] will be show in YELLOW font.

    the formula to make this work would be something like: ([text52])-
    ([text52]*([red]) = the amt that [text54] has to be =< before the font
    turns RED (otherwise it stays green)

    [text52] = $100
    [red] = 25%
    so once [text54] = < $75 then the font in [text54] turns RED.

    can anyone suggest how to set the control source in [text54] to change
    colors like this?

    thanks,
    Steve
     
    , Jan 4, 2013
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. James

    Problems with coding and coding question!!

    James, Feb 23, 2004, in forum: Access Forms Coding
    Replies:
    0
    Views:
    210
    James
    Feb 23, 2004
  2. Krutee
    Replies:
    1
    Views:
    61
    Jeff Boyce
    May 1, 2005
  3. JRB

    Continuous Forms Color Coding

    JRB, May 3, 2005, in forum: Access Forms Coding
    Replies:
    2
    Views:
    129
    Marshall Barton
    May 3, 2005
  4. Mary A Perez

    Color coding data...

    Mary A Perez, Jan 31, 2006, in forum: Access Forms Coding
    Replies:
    4
    Views:
    72
    Mary A Perez
    Jan 31, 2006
  5. Stu Campbell

    Color Coding

    Stu Campbell, Mar 8, 2006, in forum: Access Forms Coding
    Replies:
    4
    Views:
    87
  6. Color-coding in combo box or table

    , May 15, 2006, in forum: Access Forms Coding
    Replies:
    5
    Views:
    117
    Jeff Cox
    May 16, 2006
  7. SLow

    color coding datasheet

    SLow, Jun 14, 2006, in forum: Access Forms Coding
    Replies:
    2
    Views:
    99
  8. williamr

    Color Coding

    williamr, Aug 31, 2006, in forum: Access Forms Coding
    Replies:
    1
    Views:
    70
    mscertified
    Aug 31, 2006
Loading...