The following BeforeRF event procedure runs for the RM Transaction Inquiry report. If the current user is LESSONUSER1, the procedure hides two fields in the report footer:
Private Sub Report_BeforeRF(SuppressBand As Boolean) If UserInfoGet.UserID = "LESSONUSER1" Then OriginalAmountSUMRF.Visible = False CurrentAmountSUMRF.Visible = False Else OriginalAmountSUMRF.Visible = True CurrentAmountSUMRF.Visible = True End If End Sub