I have a report listing records containing a [CommitteeStatus] field. The
field contains either a 1,2 or 3. I would like to display Pending, Approved
or Denied in an unbound control named Status instead of the digits. Nothing
prints in the control unless I put something in the datasource property, but
that won't take the If statements in the code below. If what I am
attempting is possible, please advise on the proper procedure. Thanks,
Mike from Moriches

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim strCstatus As String
strCstatus = "Pending"
If [CommitteeStatus] = 2 Then
strCstatus = "Approved"
End If
If [CommitteeStatus] = 3 Then
strCstatus = "Denied"
End If
Me!Status = strCstatus
End Sub