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

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


"Murray" <(E-Mail Removed)> wrote in message
news:6C081D50-3DE3-4F1B-BFB7-(E-Mail Removed)...
> 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
>
>