Track a change in the value of a field by color coding it in Acces

[Krutee]

I am building a device tracking database for the international business of
our department using Access 2003. The manager would like to keep track of
any change made to a field "Number of Devices" after the initial entry. I
would like to know how can I color code it in a way that if it changes once
it turns Green, on second change it turns Yellow and on a third change it
turns Red. Also, I would like to know how these values can be stored. The
table has only one "Number of Devices" field, which should show the most
current updated value but the previous entry's should be stored somewhere,
where?
Please advise.
Thanks.

 

[Jeff Boyce]

Krutee

I'm not aware of Access keeping track of how many times a field has been
modified. I CAN imagine creating a table to track this information. Or, if
there is only one field for which you wish to track this, you could add a
single field in the same table.

After each change (which you can determine using the .OldValue property of
the field), you could add one to your NumberOfChanges field. By reading
this field, you could determine which back-color to use.

Good luck

Jeff Boyce
<Access MVP>