Traffic signal control

  • Thread starter Thread starter David
  • Start date Start date
D

David

My table has a 'stoplight' column, I call it a traffic
signal. It can have values of Red, Yellow or Green. Its
used in management reports. I set it up as a text field.

On my form I display it with the text and the backcolor
set to the correct color. The user cycles the colors by
clicking on the control via an ON CLICK event.

Here is my problem: when the user clicks the forward and
backward navigation controls, the back color does not
change. What is the correct event to use for this. I tried
ON CHANGE and it did not work.
 
David,

IF you're in Access 2000 or later THEN
try Conditional Formatting
ELSE
use OnCurrent Event
END IF


HTH,
Josh
 
Back
Top