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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. James

    Problems with coding and coding question!!

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

    Continuous Forms Color Coding

    JRB, May 3, 2005, in forum: Access Forms Coding
    Replies:
    2
    Views:
    131
    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:
    74
    Mary A Perez
    Jan 31, 2006
  5. Stu Campbell

    Color Coding

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

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

    color coding datasheet

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

    Color Coding

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