display part of the text Bold

[aman]

Hi All

I have written the following code but I want to display 'Agent' and 'Submission Date' in Bold.

ANy suggestions are welcome. Thanks

Private Sub lstRed_Click()
Me.txtRed = "Agent: " & DLookup("[Staff Name]", "[tblstaff]", "[Staff Number]=" & Me.lstRed.Column(2)) & vbNewLine & "Submission Date: " & Me.lstRed.Column(9)
End Sub

 

[arnelgp]

Format your textbox as Rich text. If you want to keep the formatting, format the bound field as rich text also.

 

[aman]

Arnelgp Actually I just want to display just the headers Bold and not the value .