Traffic signal control

[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.

 

[Cheryl Fischer]

Try putting your code to set/reset colors in the On Current event.

 

[David]

There is no 'On Current' event for the text box.

-----Original Message-----
Try putting your code to set/reset colors in the On Current event.

 

[Cheryl Fischer]

I should have said: On Current event for the Form.

 

[Joshua A. Booker]

David,

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


HTH,
Josh