Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 117
  • Last Modified:

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

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
thandel
Asked:
thandel
  • 2
  • 2
1 Solution
 
Berkson WeinTech FreelancerCommented:
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
 
thandelAuthor Commented:
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
 
Berkson WeinTech FreelancerCommented:
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
 
thandelAuthor Commented:
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

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

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