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

Ask a Question

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.