Conditional format of record lines in a list box

[Phonik]

A very good morning/afternoon/evening to you all wherever in the world you are.
I have a form that contains a list box which has 5 field colums in. One of these columns is a date logged for a record. What I would like to do is that if the date logged is greater than or equal to days old, I would like this record line to be in red and the remainder of the records that dont meet this criteria to remain in black. Is this possible and could any kind soul tell me how this is done and perhaps show me an example of the coding. Thank you all.

Gareth

 

[Oldsoftboss]

Not possible in a listbox I dont think, but you can simulate the same look and effect you want if you use a subform in continious form view.

 

[Phonik]

Hi

Thanks for your response but I am unsure as to what you mean?

 

[phatnq2002]

A very good morning/afternoon/evening to you all wherever in the world you are.
I have a form that contains a list box which has 5 field colums in. One of these columns is a date logged for a record. What I would like to do is that if the date logged is greater than or equal to days old, I would like this record line to be in red and the remainder of the records that dont meet this criteria to remain in black. Is this possible and could any kind soul tell me how this is done and perhaps show me an example of the coding. Thank you all.

Gareth

You use a form to do this instead of a list box, because in form, you can use a conditional formatting for each record.

I dont know that the old day is the same row with the day logged, you can say it clearly, OK?

 

[Phonik]

Brilliant! I will give this a go. Thank you.