Changing Font colour for one Record only

[Guest]

Hi all
I have a table that includes an ID, a description and a check box. If I
check the test box it should make the description change colour.
Unfortunately the code I tried changes all the following records as well.
The code I tried was on the checkbox double click event and went something
like this:

if checkbox = true then
Me.description.forecolor = RGB (255, 0,0)
else
Me.description.forecolor = RGB (0,0,0)
end if

If I use this it changes the Font colour of the record and all the following
records to red, but I only want the single record to change colour.
Thanks in advance
Murray

 

[tina]

bind your table to a *form*, and take a look at the Conditional Formatting
option on the menu bar in form Design view; i think it's on the Format menu.

hth