Data Bar / Progress Meter / Bar Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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
 
Lance said:
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.
Click to expand...

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/
 
Back
Top