How can I format a message box message display certain words in red? I would like the word "pending" displayed in red.
Here is my message box code:
Private Sub Form_Load()
If Me.RecordsetClone.RecordCount = 0 Then
MsgBox "Assessments pending for this account", vbOKOnly
DoCmd.Close
DoCmd.OpenForm "frmSearch"
End If
End Sub
Here is my message box code:
Private Sub Form_Load()
If Me.RecordsetClone.RecordCount = 0 Then
MsgBox "Assessments pending for this account", vbOKOnly
DoCmd.Close
DoCmd.OpenForm "frmSearch"
End If
End Sub