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.
afaik. you can't.
to format the titles in excel you can use
XlSheet.Range(.Cells(1, 1), .Cells(1, rst.Fields.Count)).Orienta tion = 45
XlSheet.Range(.Cells(1, 1), .Cells(1, rst.Fields.Count)).Orienta
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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