use a text box as Y axis lable in a Chart

[Zj]

in a Chat design view, i set Text.Vertical to Yes, the text box control
displays the text from top to bottom, i need the text displayed from the
bottom to the top as a Y axis lable. can we do this in Access or some simple
code in VBA.

 

[Duane Hookom]

You might be able to use a control on the report (not part of the chart).
Stephen Lebans has a possible solution at
http://www.lebans.com/xrotatetext.htm.

 

[Zj]

i need a real text box control that is able to display a data from a table.
thanks anyway.

 

[Duane Hookom]

I believe Stephen's solution can do that.