conditional formatting based on user ID

[HS_1]

I have a dBase with login form based on table tbl_User and under [Group] column one of the users is “checker”. The database also contains form frmLengthCalc. What I am trying to accomplish is that if the checker changes any value on frmLengthCalc (in text box  “txtVlv_F150_Qty” for example), the text changes colour to red and bold. I tried to use vba but the code changes the text to red for the entire column not the record and if somebody else with different rights logs in the colour goes back to black again.
Here is the code

Private Sub txtVlv_F150_Qty_AfterUpdate()
Select Case U_Groups
    Case "Checker"
    With Forms!frmLengthCalc
    Me.txtVlv_F150_Qty.ForeColor = vbRed
    Me.txtVlv_F150_Qty.FontBold = True
    End With
End Sub

I am guessing conditional formatting is the way to go so I tired but it didn’t get me anywhere either.
I used the following conditions to format [txtVlv_F150_Qty] textbox
Expression Is [tbl_User]![Group]="Checker"
And changed the text color to red and bold but it doesn’t do anything and doesn’t give me an error either.
Wonder if somebody can help me with that.

[Beetle]

It sounds like you are using a continuous (or perhaps datasheet) form, so you are going to have to use conditional formatting for this. However, you are not going to be able to use the Group field to determine the action for the following reasons;

1) You only want the text to be red if the Group is Checker, and then only if they have changed or updated certain fields

2) If the Group is not Checker, you still want the text to be red if had previously been changed by a Checker

My suggestion is the following (untested)

1) Add a boolean (Yes/No) field to the table to use as a flag
2) In the After Update event of certain controls on your form set this flag to True if the field was changed by a Checker
3) use this flag field in your conditional formatting expression to determine the color of the text.

[HS_1]

Beetle, I have done as instructed but the entire row gets red text, not only current record.

I have created only one checkbox "ChckChecker" for the entire form and behind each control I put the following code
'The one listed below is for one control
Private Sub txtVlv_F150_Qty_AfterUpdate()
If U_Groups = "Checker" Then
Me.ChckChecker = True
Else
Me.ChckChecker = False
End If
End Sub

For conditional formatting:
Expression is [ChckChecker]=-1

Do I have to have separate check box for each record ( I have 40 of them) or is there another way to limit the number of checkboxes?

[Beetle]

The boolean field needs to be at the table level, not the form level. Even if you add a check box to each row (rather than a single check box in the header, or wherever you have it now), it won't work the way you need unless it is bound to a field in a table or query. This is due to the nature of the way unbound controls behave on continuous forms. I have attached a rough example file you can look at. If you open the form, select Checker as the Group, then add a new row or update one that is not already flagged, you'll see that the text for that row changes to red. The After Update event of each text box sets the flag based on whether or not it was updated by a Checker. I'm sure you will need to tweak this some to get it to work exactly the way you want for your scenario, but it should get you started.

[HS_1]

Beetle
Thank you for your help, after some changes you suggested it works the way it suppose to.