Data Bar / Progress Meter / Bar Chart

[Guest]

Hi,

Could anyone suggest a method of having a text field (or similar) have the
behaviour of a data bar in excel 2007.

I have a field that displays a percentage and would like to present the
information to the user in a bar graph / data bar / progress meter style
appearance.

The value is only ever updated when the form is first loaded, ie. the values
will not require updating/refreshing. The data comes from a query.

It would be really great if it could change to yellow at 75% and red at 90%
as some sort of conditional format as well?

Thankyou.

 

[Guest]

You can insert the microsoft progress bar activex control, or you could write
your own pretty easily by adjusting the width and backcolor of a label.

 

[Guest]

Lance,

Thankyou for your help. I've implemented the second option by adjusting the
width and backcolour.

I'm doing this on a continuous form and have no trouble with a single
record, however when there is more than a single record the code seems to
have no affect. I'm using the On Load event, can you suggest which direction
to head?

Thanks again.
Jared

 

[Guest]

Yeah, doesn't look like that's going to work on a continuous form.

 

[Tony Toews [MVP]]

You can insert the microsoft progress bar activex control, or you could write
your own pretty easily by adjusting the width and backcolor of a label.

I would never use an Activex control of any kind if I can use a form
or API all. Way, way too many distribution and version problems. We
have replacements for everything but the treeview control.

How do you get rid of troublesome ActiveX Controls/references?
http://www.granite.ab.ca/access/referencetroubles.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/