Changing Backcolor based on change from previous record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I'm a relative novice, so here's my question. I want to be able to change the back color of a row in a form based on a change in the value from a field in the previous record. For example, if the 'sale_price' value in row 10 changes from the 'sale_price' value in row 9 (the previous record), make the back color of all fields in row 10 yellow

Thanks so much
Barbar
 
Hi,

I'm a relative novice, so here's my question. I want to
be able to change the back color of a row in a form based
on a change in the value from a field in the previous record.
For example, if the 'sale_price' value in row 10 changes from
the 'sale_price' value in row 9 (the previous record), make
the back color of all fields in row 10 yellow.
Click to expand...
-------------
Hi Barbara,

Please refer to the following article:

ACC2000: Changing Control Properties Affects All Records in a Form
http://support.microsoft.com/?id=208961

Hope this helps,

-
Eric Cárdenas
Access senior support professional
 
Back
Top