print pass instead of P access report

[kkshansid]

hi
I am using XP operating system and access 2007
Ours is a table which contains a field result with data A, P and F. I want to print report based on it.
I want to print pass instead of P and fail instead of F and so on. I made the report based on it. I know that it can be achieved through VBA .I selected the result field in report design mode on view code I write the code but I am really unable to achieve the target it still print A,P and so on in layout view.

Private Sub RESULT_BeforeUpdate(Cancel As Integer)
If (RESULT.Value = "A") Then
RESULT.Value = "ABSENT"
RESULT.Text = "ABSENT"
End If
End Sub

I am very new to this subject kindly help
Thanks in advance

[NeoPa]

This would need to be done in an After_Update() event procedure. Before_Update() will not allow you to change the control's value.

Private Sub RESULT_AfterUpdate()
    with Me
        Select Case .RESULT
        Case "A"
            .RESULT = "Absent"
        Case "F"
            .RESULT = "Fail"
        Case "P"
            .RESULT = "Pass"
    End With
End Sub

[Mihail]

Or, in the report:
Design a new text box and set it's control source as:

=IIF([FiledName]="P","Pass",IIF([FiledName]="F","Fail","Absent"))

Hide the old one (I am not sure but, maybe, you can remove it)

[NeoPa]

Agreed. I was misled by the existing code which appears to be 100% inappropriate within the confines of this question.