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.  
leewallinAsked:
Who is Participating?
 
clarkscottConnect With a Mentor Commented:
You could make the titles in Excel, <alt><printscreen> and paste in a graphic program (even Paint) , crop and make a graphic.  Use the graphic on the form or report for title.

I've done similar things....  I have a "Map" form in Access, similar to a flow chart, but it dynamically 'lights up' the current 'path' of the program in different screens (similar to a 'you are here' map beside the elevator).  I copied Word Arrows (one for each direction) and use these graphics in my Access form.

Scott C
0
 
Rey Obrero (Capricorn1)Commented:
afaik. you can't.
0
 
Rey Obrero (Capricorn1)Commented:
0
 
Rey Obrero (Capricorn1)Commented:
to format the titles in excel you can use

XlSheet.Range(.Cells(1, 1), .Cells(1, rst.Fields.Count)).Orientation = 45
0
 
Jeffrey CoachmanMIS LiasonCommented:
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


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.