Multiple column report help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to make a multiple column report. I have a table where each record
contains 20 fields. I want to display the records in a report with each
record in one column, having 6 records per page. I have been able to get
this part set up, but now I want to have labels on the left side of the page
(that only print once per page) that identify the name of each field. Can
anyone help me please? TIA
 
I have the report set up, the MS KB article you referenced gave me exactly
what I needed. Now I would like to print a report title with the company
name and date at the top of the report, centered on the page. Is this
possible? TIA
 
In design view the report is only one inch wide, the width of the column.
When I print it out, I get seven columns of data on the page. I want the
titles to be wider than one inch, and I would like them to be centered on the
page. I have tried making the multiple column report into a subreport where
I put the titles on the main report, but I can't get the columns to print out
as seven on the page when I do that, I only get one column.
 
Suzie said:
In design view the report is only one inch wide, the width of the
column. When I print it out, I get seven columns of data on the page.
I want the titles to be wider than one inch, and I would like them to
be centered on the page. I have tried making the multiple column
report into a subreport where I put the titles on the main report,
but I can't get the columns to print out as seven on the page when I
do that, I only get one column.
Click to expand...

If you go to Page Setup you can change the column settings so that they do not
need to be the same width as the report sections as viewed in design view. This
allows you to have a Report Header/Footer and/or a Page Header/Footer that is
wider than your columns. However; those are the only sections that will ignore
the column width setting. You can't for instance have columns that are 1 inch
wide and a Group Header that is wider.
 
I used code from the KB article Duane Hookom referenced to get the column of
labels to print on the left side of the report, so the actual width of the
report has to be equal to the width of the text boxes in the column. I was
hoping there was a way to put the titles up in the header, and then use vb
code to move them to the center of the page after the detail section has been
formatted.
 
I have been searching the discussion group for this same problem. I have used
the code from the KB article that Duane referenced and now have a report that
is setup with a column width of 2".

I seem a bit confused, I am trying to have a report header that is across
the whole page but no matter what I do with the column width in the page
setup dialog I cannot get the correct format. If I set up 4 columns 2" wide
with the "same as detail" unchecked and then have a header centered on the
page (Letter in landscape) I end up with 4 columns of labels not the text
info from my query. If I do not use a header and have the report width at 2"
I get one column of labels and then 3 columns of data as I need.

Am I missing something here is there really a way to have the report header
wider than the detail section or does the bit of code that I have used from
the KB article not allow me to use a header that is more than the width of
the columns.

Thanks in advance

Steve
 
Back
Top