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

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

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 (http://www.lebans.com/xrotatetext.htm) which might help.