List box with colors

[franzxx]

How I can do a form whit a list box whit different colors for each record ?

Thank you

 

[Pat Hartman]

The listbox doesn't maintain properties for each item in the list, ergo you can't control color at the item level.

 

[franzxx]

Which control can I use if i can't use list box ??????

 

[Pat Hartman]

Different colors for each record could be 3 colors or 2000. What exactly determines the color of each record? If there are only 4 variations, you can use ConditionalFormatting (choose it from the menu when you have a control selected) for controls in a continuous subform.

 

[franzxx]

The function of colors is only that the video reading is simplest and intuitive. How can i use ConditionalFormatting ?????


I am italian, i'm sorry for my terrible english!!!!!!!

Thank you Pat Hartman.

 

[Pat Hartman]

I would suggest using the help entry for Conditional Formatting but I don't know how good the translation to Italian is so I posted two pictures. One shows the formatting dialog box (open form in design view, click on control to be formatted, select ConditionalFormatting from Format menu). I chose the expression option and entered an expression that would color all ID that are even, red. The odd values retain their default properties. The other picture shows the form in datasheet view so you can see the alternating colors.