MS ACCESS: REPORTS - on format event procedure 1

[PPJOSEPH]

I have a field where the user enters codes like A1P or A2C or A3B. The code represents A1P - Online; A2C - Classroom; A3B - Self-study;

In the report, now it shows these codes, instead, I would like what the code represents.

The report should replace A1P to Online and A2C to Classroom etc.

This is what I did and obviously but its not working.

In the section where that textbox appear, I added a new unbound textbox and named it "MyMask"

I made the original text box hidden. The original text box is named "PCC"

In the report section "OnFormat" event procedure I added the following code

Select case MePCC
Case "AIP"
Me.MyMask = "OnLine"
Case "A2C"
Me.MyMask = "Classroom"
Case "A3CB
Me.MyMask = "Self-Study"
End select

As I mentioned, its not working. Can someone help me out. Thanks, in advance.

 

[M8KWR]

your code is wrong use

Select Case Me.PCC
Case "A1P"
 Me.MyMask = "OnLine"
Case "A2C"
 Me.MyMask = "Classroom"
Case "A3B"
 Me.MyMask = "Self-Study"
End Select

 

[PPJOSEPH]

Thanks you so much for your quick answer. It was really helpful. Thanks again.