Data Bar / Progress Meter / Bar Chart

J

Jared

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.
 
L

Lance

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.
 
J

Jared

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
 
T

Tony Toews [MVP]

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.

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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Progress meter Help 2
Bar Chart with Data Elements 1
Progress bar based on percentage 3
Prevent interruption of status bar meter 7
Static Meter 2
Static Meter 2
query progress meter 8
Semi Circular Meter 2

Top