I have a form f_Details which has six columns from the source table t_Details. One of the columns is col_Name and another column is checkbox_YN. Some of the names in the table that are no longer with the company have the checkbox checked Y. In the form f_Details I need the col_names to change the forecolor to red if the name on that row is no longer with the company and the checkbox is checked Y.

All assistance would be greatly appreciated. Thans for your time.

I have tried the following in the “Got Focus” event of col_Name:

> Private Sub col_Name_Got Focus()
> If Checkbox_YN.Value Then
> col_Name.Forecolor = RGB(0, 0, 0) 
> Else
> col_Name.Forecolor = RGB(255, 255, 179) 
> End If
> End Sub