listbox

[NT100]

I've a listbox in which each item is examined for a condition. If the condition is met，the element will turn to green colour.

What would be suggested?

Thanks in advance.

NT100

 

[Ranman256]

Cant. You can for datasheet records, but not for a listbox.

 

[NT100]

datasheet record? how?
My listbox is working for ACCESS.

 

[Minty]

You could make a continuous subform that looked just like a listbox, and colour that.
Or a datasheet using conditional formatting.

 

[Mark_]

datasheet record? how?
My listbox is working for ACCESS.

Create a form on your table. Place each field that you would display on your form. In Form properties, set Default View to be Datasheet. You can then conditionally colour each field for each record as you need.

Place the new form on your existing form in place of your listbox.