Conditionally formatting bar charts

[Jim L.]

I am working on a layout report of my fuel station that shows each pump, the
related tank, and a product type. Inserted onto the report is a chart that
shows the level (percent) of each tank. The pump/tank number text boxes are
conditionally formatted to change color depending on the product type
selected when completing the related form. Is it possible to also format the
bars in the chart to change color to match the text box formats?
This doesn't happen too often, and I am used to doing it manually in the
Excel version I am currently using. I'm really not expecting this to be
possible, but if someone blows me away with a way to do it, I would be
impressed and grateful.
Thanks, as always
Jim

 

[Rob Parker]

There's been a number of threads on this topic in several of the Access
newsgroups recently. One that I contributed to recently is here:
http://groups.google.com.au/group/m...e_frm/thread/1dc76af70edfdb1/7bf7191d3898b9e9

Another, earlier one, is here:
http://groups.google.com.au/group/m..._frm/thread/eca65c6047979c37/454ec9311ecdcdb6

And another one - more recent, and using a slightly different approach - is
here:
http://groups.google.com.au/group/m..._frm/thread/c5d7dc66294792e8/a50c50bdcb593d5e

Check these out, and post back with specific questions if you need more
help.

Rob