Chane the Color of the Last entry in Text Box

[othmanyg]

Greetings to all,

How can I change the color for example to red for the last entries in a text box field. Note that I'm using the following code (After Update) to stamp the date, time, and the person who has done the entry.

Dim s As String
Dim ss As String
s = Status.Value & "."
ss = s & " " & crlf$ & "Updated by: " & Assigned.Value & crlf$ & ". on " & Now
End If
End Sub

I need only the newer entries or update in the text field to be in red and the upper previous entries in the same filed change back to black whenenver newer updates occurs.

I appreciate your help as always.

 

[RuralGuy]

If it is really important you may want to investigate Stephan Leban's Rich Text.

 

[othmanyg]

It did not work

thanks RuralGuy, I found good samples and codes in that link but i still could not fix my problem and i did not find a workaround yet.

Please help.
Thanks

 

[RuralGuy]

I take it the Status control is displaying a Memo field and you are allowing the user to edit this field directly. I would recommend using the BeforeUpdate event to append the timestamp info. I have not played with Stephan's RichText control yet but it brings up some questions. The color is for display only so could you do it with two controls; one for what is already in the field and one (in red) for the new comments? What would you expect to see if you closed the form and opened it again? Would anything be in red?