Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Unanswered: Changing Backcolor based on an form value

    Hiya

    I have a form that displays a recordset using the Continuous Forms view. Within this RS I have 2 fields one of which I would like to change the background color on depending on one thing.

    If field1 is greater than field2 then field1 background color is to be green, else the background color is red.

    Where would i place the code in order for it to affect each record in the RS?

    Cheers
    Gary

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Changing Backcolor based on an form value

    Originally posted by gand68
    Hiya

    I have a form that displays a recordset using the Continuous Forms view. Within this RS I have 2 fields one of which I would like to change the background color on depending on one thing.

    If field1 is greater than field2 then field1 background color is to be green, else the background color is red.

    Where would i place the code in order for it to affect each record in the RS?

    Cheers
    Gary
    Conditional format. pull up the properties an d click on coditional formatting ...

  3. #3
    Join Date
    Mar 2004
    Posts
    4

    Re: Changing Backcolor based on an form value

    Originally posted by M Owen
    Conditional format. pull up the properties an d click on coditional formatting ...
    Many thanks M Owen, you were a great help

    have a great weekend.

Posting Permissions

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