Using html code to format items in a combobox

[Henners]

Hi all,
I am trying to get a combo box to display a list of items but if the items fit a certain criteria then part of the items text will be another color.
I.e. If the item in the list says "week 1 ---> homework " then I want to change the word homework to red.
I had a little play around with a textbox and used the following:


Me.Text3.TextFormat = acTextFormatHTMLRichText
Me.Text3.Value = "<p><strong>He<span style=""color: #ff0000;"">ll</span>o</strong></p>"

All fantastic the ll in Hello is red. But there is no textformat property for a combobox.
Does anyone know of a way to do this without using a textbox ?

Side note: The html is coming directly from the field and is not being modified at runtime. I do the manipulation in a stored procedure and then put the end results into a field. Setup is MSSql db with an Access front end.

Thank you kindly H

[Micron]

AFAIK it is not possible to format list item. Anything you'll find re conditional formatting or whatever, applies to the displayed value, which I think is not what you're asking for. I have read that there is/was an ActiveX control called ImageCombo with which you could display small icons to add a bulleted effect but I'd caution against using any non standard Access control. Other than that, you'd have to fake it with a small continuous form or something similar. A lot of work for little payback IMHO.

[isladogs]

You can do limited formatting for both combos and listboxes. See http://www.mendipdatasystems.co.uk/a...our/4594424152
However, whether this offers enough to meet your needs is another matter.
Alternatively, you could use a subform to mimic a combo and make use of the additional formatting available in the underlying query.

[Henners]

Owww that's a bit of a bummer. Well I think I will just add a textbox and populate it with the html code. Hide the lstbox and then when the user clicks on the textbox show the listbox and setfocus to it.
Not sure how it will work out but I will aim for something like that.
Thanks for taking the time to answer me Micron and isladogs much appreciated.

[Henners]

Owww that's a bit of a bummer. Well I think I will just add a textbox and populate it with the html code. Hide the lstbox and then when the user clicks on the textbox show the listbox and setfocus to it.
Not sure how it will work out but I will aim for something like that.
Thanks for taking the time to answer me Micron and isladogs much appreciated.

That cunning plan did not work. The end result was an formatted text box. Just does not seem to want to play ball when it is a datagrid.

[isladogs]

As previously suggested, why not use a subform that has similar functionality but more potential for formatting the way you want

[Henners]

As previously suggested, why not use a subform that has similar functionality but more potential for formatting the way you want

Isladogs I am lost on that one. Have you got an example you could share with me?

[isladogs]

Which part don't you understand?
You can use a continuous or datasheet subform with one or more fields (columns) so it looks similar to a listbox
You can use conditional formatting to make the appearance exactly as you want - HTML wouldn't be used (or needed)

However if you want HTML formatting, you can use a memo field set as 'rich text'

I've attached an example of each in case they are any use