text color help

Hi! I was looking for some help about text color and caught your site. I am working on a project where the text in between two fields from a table retrieved by SQL should be shown in different color.
strsql = "select field1 & "" some text"" & field2 as field from table"

the result is put in a list box and i have to change the color of "some text". How is this possible? Any help?

My email: [email protected]

your kind advice is very much appreciated.

What is wrong with using the listbox's forecolor property.

i.e. Listbox.ForeColor = vbRed.

Mega.

Here is a suggestion. It's a very simple example using an RTF box.

I tried all the methods but couldn't succeed. Each listbox item should be "some text-redtext-sometext". normally listbox doesn't have these capabilities.. but is there a workaround...

something like that?

-> Text redtext othertext ??

no idea!

cya