Multi-Column Reports

Posted on 1997-11-11
Medium Priority
Last Modified: 2010-08-05
How do I place an unbroken line between the columns of a multi-column report?

I'm using Access 2.
Question by:rrew
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
  • 4
  • 3

Expert Comment

ID: 1959258
Do you have a line draw capability?  I am not using Access2 so I don't know what the features include.  If you have the ability to draw lines, draw a verticle line.


Expert Comment

ID: 1959259
Go into Design mode for your report.
Choose View/Toolbox if it is not already checked.
Depress the button on the toolbox that looks like a backslash.
Draw the vertical line in the detail section of your report.

Author Comment

ID: 1959260
This is one possible solution, but not perfect.  As the report is multi-column, this will produce the line at the right or left of each column.  My report is two columns wide, and I only want the line to appear down the centre of the two columns.

Nice try though.
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Expert Comment

ID: 1959261
Oh, when you mean 2 columns you don't mean 2 columns from your table do you?  My example works fine if you are doing a 1 column (full page) report that has 2 (or more) columns of data on it.  Then you can position the line in between the columns no problem.  That is what you are doing, right?

Author Comment

ID: 1959262
The report generates the columns for me.  Imagine a report which generates mailing labels.  My report is similar to this.  I just need a way of adding the elusive line between columns.

What makes it even more frustrating is that I could could in Word with one click of the mouse.


Expert Comment

ID: 1959263
The problem is that to build such a report in Access you only put 1 field in the detail area, and then it duplicates it for each column in your report.  So if you have used Print Setup to define a 2 column report, as I think you have, then in the detail section of your report it will double everything, including the line you draw in.

Accepted Solution

jscrouch earned 300 total points
ID: 1959264
Ok, I managed to do a totally kludgy workaround that I think is the only way to do what you want.  Sad to say I tried it in Access 97 too and it looks like it still behaves the same way as 2.0, so upgrading isn't an answer!

In the detail section of my report I have a column and a line, the line is at the 3" mark.  In Print Setup I have defined a 2 column report with item size the same as detail.  When I print the report I see the first column of data, the line in roughly the middle of the page, the second column of data, then nothing, looks like the other line gets dropped.  You may have to play around with the line positioning, but it can be done.  Kludgy, but possible.

Author Comment

ID: 1959265
I agree : Not ideal, but it works.

Many thanks...

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

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
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

777 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