I would like to create a graphical bar on a form to show the percentage progress of a project from a value in a table. Any ideas how I can achieve this?

Many thanks,
Duncan

There is a ProgressBar OLE object (actually there's more than one) to do this if you click on the 'more controls' button on the toolbox bar in form design, but I prefer to make my own using the 'box' items; you can alter the width (or height) of a box item programmatically in VBA and it has the advantage that you can make the colour change as it goes up etc.

if you have trouble setting it up, let me know and I'll bash out a little demo.

Mike

Hi Mike,

Thanks for this, a demo would be very helpful.

Many thanks.
Duncan

Your email address isn't available on the forum; if you email me at it@nylabone.co.uk I'll send it on the reply

Mike