'Static' progress bar in list box column

[akshatagarwal93]

Hi,

I'm quite new to access and VBA so wasn't sure exactly how to word this without writing an essay so maybe this has already been posted...

My database basically stores data about how 'complete' a certain transaction is. This is stored in a table called Transaction Details with a percentage detailing how complete the transaction is.

I want to build a list box programmatically in a form so use the listbox.AddItem property on the form_load event. I want one of the columns of the list box to show the percent completion of the corresponding transaction but instead of just displaying the percentage, I wanted it to show some kind of 'static' progress bar. So if it was 50% complete, half of the box would be coloured say dark blue and the other would be white and so on for different percentages. It should also show the percentage as a number on top of this...

Is this possible? - I've searched around for some sort of colouring technique to change how much is blue and white etc but couldn't find anything.

Any help and ideas are massively helpful!

Thanks

AA93

[June7]

Nope, can't do that. Never seen such a requirement.

Only thing I could suggest is a graph object with minimal features and sized small enough so it looks like a single bar.