ChrisCione
Board Regular
- Joined
- Aug 27, 2008
- Messages
- 92
- Office Version
- 365
- Platform
- Windows
How do I combine these two subs into one (On Format event of a report's detail section)?
and
Many thanks in advance.
Code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Nz(Me.txtReferralIssuedDate) = 0 Then
Me.txtUSAJobsCloseDate.Visible = True
Me.lblREFERRALISSUED.Visible = False
Else
Me.txtUSAJobsCloseDate.Visible = False
Me.lblREFERRALISSUED.Visible = True
End If
End Sub
and
Code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Nz(Me.txtReferralReturnedDate) = 0 Then
Me.txtReferralDueDate.Visible = True
Me.lblRETURNED.Visible = False
Else
Me.txtReferralDueDate.Visible = False
Me.lblRETURNED.Visible = True
End If
End Sub
Many thanks in advance.