Conditionally Formatting lines in a ListBox

[Guest]

Is there any way to change the colour of certain lines in a listbox?

For example, if a date is less than Date(), then highlight that particular
line in Red, otherwise leave it as default colour.

My listbox consists of 5 columns, with various details but the identifying
condition to look for is the Expiration date being less than todays date.

Thanks

 

[Allen Browne]

No, the list box cannot do that.
Use a subform instead.
You can then use Conditional Formatting on the controls.

Other possible altenatives (without testing them):
http://www.lebans.com/customlistboxver3.htm
http://www.lebans.com/listboxenhanced.htm