?
Solved

MS access is it possible to have various column widths for a single report

Posted on 2015-02-20
4
Medium Priority
?
114 Views
Last Modified: 2015-02-26
I am familiar with how to create a report with more than one column.  Is it possible to have multi column widths  in the same report, for example page header 1 column and then the detail section 3 columns?
0
Comment
Question by:thandel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 15

Expert Comment

by:Berkson Wein
ID: 40621388
Sure it is.  If you go into the design view for the report, you should be able to modify it to your heart's content.  If you're struggling, maybe post the mdb with more explanation?
0
 

Author Comment

by:thandel
ID: 40621410
I only see a column setup in the page setup... which seems to affect the entire report.  Is there another place to set columns per section instead of per page?
0
 
LVL 15

Accepted Solution

by:
Berkson Wein earned 2000 total points
ID: 40621431
Oh oh oh.  I'm sorry, i thought you meant different table columns (equivalent of columns A, B, C... in excel).

To do what you're actually requesting, I suggest doing a report and subreport. The report would have 1 column, and the subreport (which is embedded into the main report) would have 3.
0
 

Author Comment

by:thandel
ID: 40633298
Actually I found a solution... I the column setting uncheck  to note make column with same a details... then set the desired number of columns and their width.  Now the headers can be set to full page width AND you will have the columns fitting as needed.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

719 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