Solved

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

Posted on 2006-11-22
5
750 Views
Last Modified: 2013-11-28
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
Comment
Question by:leewallin
  • 3
5 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 17998380
afaik. you can't.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 17998387
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 17998420
to format the titles in excel you can use

XlSheet.Range(.Cells(1, 1), .Cells(1, rst.Fields.Count)).Orientation = 45
0
 
LVL 20

Accepted Solution

by:
clarkscott earned 500 total points
ID: 18001506
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 18067797
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question