I am converting an Excel dashboard into an Access report. I'm stuck on a formatting issue. I've attached a screen shot of the rough report.
I have box controls whose height is dependent on calculated field. I used the following code to define the sizes of the boxes:
Code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Box18.Height = ([P1St]) * (1440 * 0.5)
Box24.Height = ([P2Par]) * (1440 * 0.5)
Box28.Height = ([P3Foc]) * (1440 * 0.5)
Box30.Height = ([P4Det]) * (1440 * 0.5)
Box34.Height = ([P5Sent]) * (1440 * 0.5)
Box36.Height = ([P6Gram]) * (1440 * 0.5)
End Sub
The controls resize correctly. However, they grow from the top down, so instead of a column chart, I have stalactites (the green lines on the report are for visual reference only). Is there a way to anchor the controls so they grow from the bottom up?
I am trying to bypass MS Graph, which is too cumbersome and inflexible for my ultimate design.
Any help would be appreciated.