Formatting message box

[cjany]

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

 

[Dibblet]

It's a bit of a long way round and I'm not sure if it's particularly correct for your requirements but a simple fix would be to produce a form that pops up instead if you remove all the toolbars etc. it is much more easy to change is appearence.

 

[cjany]

Thanks, I just changed the wording in the message box a little to emphasize what it needs to say.

 

[ZmrAbdulla]

http://www.ace.co.nz/tips/view_tip.asp?Tip=270

may help you.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.