Link to home
Start Free TrialLog in
Avatar of leewallin
leewallin

asked on

MS Access Reports - Can you make slant titles like Excel?

I have data that I need to show with long column heading titles. In a report, can you make column headings slanted like you can in Excel?  If not, is there a way to export the data into Excel with a preformatted header with slant titles.  
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

afaik. you can't.
to format the titles in excel you can use

XlSheet.Range(.Cells(1, 1), .Cells(1, rst.Fields.Count)).Orientation = 45
ASKER CERTIFIED SOLUTION
Avatar of clarkscott
clarkscott
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
leewallin,

FMSInc. has an ActiveX cotrol to rotate text:

http://www.fmsinc.com/products/components/index.html

$200 US though!
:O

Personally, I would go with clarkscott's "Print screen" solution.

Good luck!

:)

Jeffc