?
Solved

MS Access Chartspace ticklabel orientation property

Posted on 2009-05-12
4
Medium Priority
?
744 Views
Last Modified: 2013-11-28
Hi Experts,

I am building a linechart in using the OWC charting component using VBA in MS Access. I need help setting the Y Axis tick label orientation to downward. I dont have access to the object library to find the correct syntax. Is there anyone that can help with this?

Thanks,

smartin76
0
Comment
Question by:smartin76
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24371305
smartin76,

Since you did not post any of your code, I cannot give you any guess as to what your exact syntax might be.

So here is the general syntax:

ActiveChart.Axes(xlValue).TickLabels.Orientation = xlUpward


JeffCoachman

0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 200 total points
ID: 24371314
oops,  that is for Excel.

The Access syntax might be:

ActiveChart.Axes(acValue).TickLabels.Orientation = acUpward

...but I am sure you get the idea.

;-)

JeffCoachman
0
 

Author Closing Comment

by:smartin76
ID: 31580834
Worked like a charm! Thank you!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24379207
Great!

0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question