Conditional Formatting of Row 1

[TBOB]

I have a report that has 4 columns. One of the columns is the result of a check box in a form. What I'm trying to do is anytime the value of that text box in the report = -1 change the backcolor of the other three columns in that row. Here is what I have so far:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If Me.txtMIDPOS = -1 Then
Me.txtSECNUM.BackColor = 255
Me.txtSECIDENT.BackColor = 255
Me.txtSECNAME.BackColor = 255
End If

End Sub

It doesn't change anything. Right now I know there are 7 instances where the txtMIDPOS value is -1, but when I step it through the code it is seeing 11 instances. Any help would be appreciated.

Thanks,

Tony

 

[dhookom]

First, you probably need to add an "Else" section to the code to set the BackColor to vbWhite from vbRed. Then, make sure the control backgrounds are not set to transparent.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[TBOB]

Both items mentioned were required. Thanks for the help.

Tony