Setting items in a listbox to bold

[odrap]

1)Is it possible to set items in a listbox to bold, if this items meet some condition(s), without the need of using an activex control?

2)I knowthat the use of MSCOMCTL.ocx makes it possible to give some items a predefined foreground color if some condition is met. I also know that this activex is in c:\Windows\system32 folder, but how do i add a reference to this control in the reference list in the vba editor? The reference to this activex isn't present in my reference list.
Does this control also makes it possible to select items and moving them to a second (normal) listbox , or do i have to use two such a activex controls to simulate the moving of items from one listbox to the other and vice versa?

 

[John Big Booty]

With the form in design view, click on the combo and then set the font size, colour boldness, etc. as required.

 

[missinglinq]

You can do this with a Combobox, John, but you can't do it with a standard Access Listbox. I'm guessing that's because , with Multi-Select set to Simple or Extended, the Listbox has no Value Property.

That aside, the OP is speaking of an ActiveX Listbox, not a standard Access Listbox.

Did you try the advice on the link wiklendt gave you, the first time you posted this question, twelve hours ago?

 

[John Big Booty]

My bad. I must admit I did not initially test the method I suggested on a list box. However having done so, I have discovered that list boxes behave in exactly the same manner as a Combo when it comes to formatting the text within them, irrespective of the Multi Select property.

However having re-read the OP it would appear that odrap is talking about Conditional formatting, rather than blanket formatting, which is what I missed on my initial reading of the post. And yes that will most definitely not work on a list box.

 

[missinglinq]

The monkey boys getting the upper hand, are they?

I have a friend who has the same problem with Flying Monkeys!

 

[John Big Booty]

Is her name Dorothy?

 

[odrap]

I have seen the demo and i'm convinced that this is a powerfull solution. I only wonder if with such an activex it is also possible to pick items from the list and move them to another normal listbox and vice versa. In my program this is necessary , because the user must get a view of all the items he or she selected, and have the possibilty to deselect an item in case of a wrong choice. I also heard about a lot of problems by using activex in a program, and therefore i doubt about using them in my program, reaso why i asked about making some items in a normal listbox have a bold text. It seems that making some items in a listbox having another color, is quiet possible in vb.net. Why after all this versions of MS Access,with all these troubles to update a older version to the new one, isn't it still impossible to do that here! Is that a planned strategie to push developers to abandoned MS Access and switch to vb.net or C#?

 

[boblarson]

Is that a planned strategie to push developers to abandoned MS Access and switch to vb.net or C#?

Not that I've seen (and I've seen the next version - Access 14).