printing a page header atop each column

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I have a simple access report that displays two fields.
Rather than have the report print on 2 pages (which it
does right now), I want it to print 2 columns on the same
page.

Problem is that I can't get the labels for the two fields
to display at the top of each column. What I want is:

Name Count Name Count
------ ------ ----- ------
Fred 3 Bob 8
Barney 12 Ted 34
Wilma 0 Carol 6
etc. etc. etc. etc.


But what I get is:

Name Count
------ ------
Fred 3 Bob 8
Barney 12 Ted 34
Wilma 0 Carol 6
etc. etc. etc. etc.

Anybody know how to do something as simple as print the
labels at the top of each column without having to write
about 300 lines of code? In essence, I want to get access
to treat a column break in the same way it treats a page
break.
 
Ron said:
I have a simple access report that displays two fields.
Rather than have the report print on 2 pages (which it
does right now), I want it to print 2 columns on the same
page.

Problem is that I can't get the labels for the two fields
to display at the top of each column. What I want is:

Name Count Name Count
------ ------ ----- ------
Fred 3 Bob 8
Barney 12 Ted 34
Wilma 0 Carol 6
etc. etc. etc. etc.


But what I get is:

Name Count
------ ------
Fred 3 Bob 8
Barney 12 Ted 34
Wilma 0 Carol 6
etc. etc. etc. etc.
Click to expand...

Multi-column reports can have a Report Header/Footer and/or Page Header/Footer
that is the full width of the final output. Then you can manually place
multiple copies of your column header labels across the top of the page. You'll
need to go into you PageSetup and change the column-width property so that
instead of adopting the width of your report sections you enter a specific width
value. It will take a few tries (or some math) to get the other column labels
positioned correctly, but it takes no code whatsoever.
 
Back
Top