I have a field of which I want to reference in a report, but if another field = true then I would want to change the output to a different name.
Field 1..........Field 2.........Output
Approve........False...........Approve
Approve........True...........Approved
I was thinking you could make the field unbound and go that route and do it on an unbound field. I'm still figuring out the color codes. if you have a reference for the color codes...
Private Sub Vote_BeforeUpdate(Cancel As Integer)
If Me.AO_Vote = "Approve" And Me.Action_Complete = True Then
Me.Vote = "Approved"
Me.Vote.BackColor = RGB(0, 235, 0)
Else
Me.Vote = Me.AO_Vote
End If
End Sub