Label Alignment

[MarieD]

Can you tell me how to make the labels in my access report to appear in the same diaganol alignment as in the attached sample excel spreadsheet?

Thank you

 

[Endre]

Hello, The same way you would in Excel - In the design view of the report, double-click to edit detail of the report, then (e.g) double-click on the x-axis labels and you will get a properties tab "Format Axis". Choose the tab "Alignment" and set to 82 degrees.

If you want to set the value programatically via VBA Code or maybe change it to a different value based on data, or logic of some sort - then that's another much more detailed post required.

Hope this answers your question,

Kind Regards,
Endre

 

[SOS]

Well, actually you cannot do this natively in an Access Report (a chart, perhaps, but not a report).

You can check out this from Stephen Lebans which might help.