I have an unbound text box into which I use VBA to load a string. I am reading through a small table to get "tag" words associated with a transaction and I build a string. The code for this is below:
Code:
Do While Not rs.EOF
If Len(CaseTags) > 0 Then
CaseTags = CaseTags & ", " & "<font color=red>" & rs!TagTitleMinor & "</font>"
Else
CaseTags = " " & "<font color=red>" & rs!TagTitleMinor & "</font>"
End If
rs.MoveNext
Loop
I change the ControlSource of the text box and it shows up as follows:
Is there any way to change the font background color - not the background of the entire text box, just the string text? For example, black text on a gray background in a white text box.
Thanks in advance.