• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 777
  • Last Modified:

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.  
0
leewallin
Asked:
leewallin
  • 3
1 Solution
 
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
 
clarkscottCommented:
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
 
Jeffrey CoachmanCommented:
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now