Changing a text field output for a report.

[Thompyt]

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

[June7]

Should consider Conditional Formatting for coloring.

Saving calculated data is usually not advisable. This value can be calculated when needed.

[Thompyt]

June7,
I am playing with the colors, I already have Conditional Formatting under control. Just wanted to figure out the VBA way. I am not saving a record, just changing the output of the text when another field activates it. The original fields will stay the same. I do this becuse there are other reports that need to have the original text in them. This report would use both and would be grouped on the output and the activating field.

[June7]

This code is behind a form? Is it Continuous or Datasheet? Programmatically changing color of textbox will not work nice on those form views.

[Thompyt]

Its behind a report.

[June7]

Why would BeforeUpdate event be used behind a report? Data cannot be edited through report.

Use IIf expression in textbox ControlSource:

=IIf(AO_Vote = "Approve" And Action_Complete = True, "Approved", AO_Vote)

[Thompyt]

Thank June7,
That makes more sense. No worries about the color. i am still using the Conditional Formatting.

[Thompyt]

What about 2 values? I have 2 of three values OK. One doesn't change.

=IIf([Action_Complete]=True And [AO_Vote]="Approve","Approved" [AO_Vote]) Or IIf([Action_Complete]=True And [AO_Vote]="Deny","Denied" [AO_Vote])

[orange]

Not understanding your syntax. What do you mean by the the "Approved" [AO_Vote] and ,"Denied" [AO_Vote])

This is the general IIF syntax

=IIf([Action_Complete]=True And [AO_Vote]="Approve", ThisIfTrue,ThisIfFalse)

[Thompyt]

Orange,
That is what I am trying to get. I have this for one type:
=IIf([Action_Complete]=True And [AO_Vote]="Approve","Approved" [AO_Vote])

I want to add this in (Combine) also:

= IIf([Action_Complete]=True And [AO_Vote]="Deny","Denied" [AO_Vote])

but if I put an Or in I get the error.

[orange]

What exactly is it in plain English?
In your example
[Action_Complete]=True is the same in both.

[June7]

Mod Edit: merged threads

=IIf([Action_Complete]=True And [AO_Vote]="Approve", "Approved", IIf([Action_Complete]=True And [AO_Vote]="Deny", "Denied", [AO_Vote]))

[Thompyt]

Thanks June7,
Works, and I added to it. Much appreciated.