change the color of the lines of the list box forms

[hys408]

The piece of code of the program to change the color of the lines of the list box forms with a special condition in Microsoft Access

 

[theDBguy]

Hi. Welcome back to AWF!

Was that a question? Or, were you trying to share something you created?

What happened to your old account?

 

[ComputerVersteher]

Hi hys408,

a salutation is always a good start and a sentence should usually contain a verb

ListBoxes can't have a conditional format, but you can use a subform instead (includes filters and sorting too).

You can access the conditional formats of a control by looping its .FormatConditions collection.

 

[MajP]

alternating row colors in ListBox

Hi All. Is it possible to create alternate row colors in a form ListBox control in VBA Access? If yes. Can someone show how it to do? Is it possible to change font in header ListBox? Thanks

www.access-programmers.co.uk