Recent content by JSmith

Wow it looks great! I am actually working in a report, but many times things that work in forms will work in reports, so i am going to try an carry it over. Thanks for all the help. Jsmith

I tried to insert a image; however, it wanted a url, so basically i could not figure out how to attach it. Anyway maybe i can describe it better. The chart is a stack chart. The number of items in a stack can flux, and not every stack has the same number of items. Example: in stack one it can...

The myBarObject.Backcolor = vbRed works well to set the back color of the chart; however, i am having an issue with selecting a certain bar, such a bar that draws the data for ford, another will draw data for chevy, and etc. the issue i am having is figuring out how to set bar color ford to vbred.

I have an access bar chart that the color keeps changing on the bars everytime i open it. Is there some way in VBA I can set the bar color. Example: RC1 bar will be red one time and yellow the next time i open it. Thanks, JSmith