Multiple headings on multiple columns

  • Thread starter Thread starter Isaac Koch
  • Start date Start date
I

Isaac Koch

Hello,

Is it possible to have a heading on each column on a multiple-column report?
The heading I'm looking for is a static one, one that doesn't change with
the text. I tried producing the text from a VB function, but unfortunately,
for each column heading, I lose one row of data.

The data I'm working with is sorted by a list of 3-didgit numbers.
Thanks for the help,

Isaac Koch
 
Isaac said:
Is it possible to have a heading on each column on a multiple-column report?
The heading I'm looking for is a static one, one that doesn't change with
the text. I tried producing the text from a VB function, but unfortunately,
for each column heading, I lose one row of data.

The data I'm working with is sorted by a list of 3-didgit numbers.


Presumably, you're talking about the Page Header.

If so, maybe all you need to do is change the Columns
settings in the Page Setup menu. If you uncheck the Same as
Detail box and specify the column widths explicitly, then
you can make the report's design width as wide as the paper
less margins. You can now use the full width of the Page
(and Report) Header/Footer sections to add labels for the
other columns.
 
I tried setting the "Same as Detail" box, but that doesn't help. I'm trying
to put the same number of headings on my report as there are columns. When
there's only one column, I want one heading. With two columns, I need two
headings, and so on. The headings are to be identical. Do you know if this
is possible?
Thanks for your help.

Isaac Koch
 
Isaac Koch said:
I tried setting the "Same as Detail" box, but that doesn't help. I'm trying
to put the same number of headings on my report as there are columns. When
there's only one column, I want one heading. With two columns, I need two
headings, and so on. The headings are to be identical. Do you know if this
is possible?


You were supposed to UNset the "Same as Detail" box so you
can make the report width wide enough to have multiple
copies of the header label(s?) across the page header
section.

AFAIK, You have to set the number of columns in design view
so you can easily edit the page header too.
 
Obviously. Now, at least. Thanks for the help. I completely overlooked
that turnong that off would do the trick. The detail section is now
independent of the heading section. Do you have any suggestions on how to
automatically hide the extra headings when there is less than the total of
three columns?
Thanks again,

Isaac Koch
 
Isaac Koch said:
Obviously. Now, at least. Thanks for the help. I completely overlooked
that turnong that off would do the trick. The detail section is now
independent of the heading section. Do you have any suggestions on how to
automatically hide the extra headings when there is less than the total of
three columns?


I **might** be able to come up with some complicated
technique, but, IMO, it's not worth it. The difficulty is
that the page header is formatted before the details on each
page, so somehow you'll have to get the last detail (in each
group?) to remember which column it's in and, by forcing the
report to be formattted a second time, get the page header
to use the saved position of that last detail to make some
lables visible or not.

If you feel you must pursue this, please explain (in a lot
more detail) how your report is layed out. E.g. CanGrow,
Sorting and Grouping headers/footers, etc. It might even
depend on what version of Access you're using.
 
Thanks, Marshall.

I think I'll try it myself--I hope it works! I think if I put a text box on
each record, and calculate how many records are in column, I can have the top
record for each column make its heading visible. I'll write with updates.
Thanks,

Isaac Koch
 
It seems to be working, now. When the page header is formatted (OnFormat
event), code determines the record count and then determines, given the
maximim number of columns and the maximum number of rows per column, how many
columns of data are on the page, and what column the last row is in. From
there, and given the page number (report.page), it determines if the OnFormat
event is running for the last page of the report, and if there are less
columns of data on the report than the maximum number of columns.
Does this make any sense to you?

Thanks,

Isaac
 
Back
Top