Solved

How to draw a vertical line in microsoft access report detail section?

Posted on 2004-09-21
9
759 Views
Last Modified: 2013-11-28
hi,
I have invoice report that need to be printed in a full page report.

The problem is that I need to draw vertical lines in my  detail section that need exactly to be 5 inches long even  even if only 1 or 2  data  appear in the report.

I hope u guys understand what i mean..... thks



0
Comment
Question by:cutemouse
  • 3
  • 2
  • 2
  • +1
9 Comments
 
LVL 18

Expert Comment

by:Data-Man
ID: 12116929
Set your detail section to 5 inches and draw a vertical line 5 inches.

Mike
0
 
LVL 18

Expert Comment

by:Data-Man
ID: 12116942
oh I see the problem...won't work....

what happens when the data in the detail is longer than 5 inches...should like still be 5 inches?

Mike
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 12116949
(A wild stab) In your report reate a subreport that's five inches tall.  Then create the vertical lines on the main report, right on top of the subreport.  Then, select all vertical lines and go to the Format menu item, Bring to Front.

Like I said, this is a wild stab.  I don't think this can be done in a really clean manner in Access.

Hope this helps.
-Jim
0
 

Author Comment

by:cutemouse
ID: 12117023
after 5 inches ... should go to the next page...

the data is a buying transaction of a shop

report sample

-----------------------------------------------------------------------
|article no  |  Description |  unit order | unit price | sub total |
-----------------------------------------------------------------------
| 1            | aa              |         5       |       $1    |      $5     | ---
| 2            | bb              |         1       |       $2    |      $2     |    |
|               |                  |                  |              |               |    |---->  5 inches  
|               |                  |                  |              |               |    |
|               |                  |                  |              |               |----
-----------------------------------------------------------------------
                                                        grand total        $7

somothing like this.. so even the data is 2 ... but i want to make the vertical line in 5 inches.  

thks for the reply
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12117027
You could use the Line method. In the OnPage event of the report, you could do something like this:

Report.Line 1440, 0, 1440, 7200

This would draw a vertical line 1 inch from the left and 5 inches long. The arguments go:
Line top x, top y, bottom x, bottom y

Measurements in this case are in twips (1440 to an inch). You can set it to use other measurements instead.
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 12117101
Perhaps a better idea would be to avoid this altogether and ask the client why this silly requirement exists in the first place.

I can always dream...
0
 
LVL 18

Expert Comment

by:Data-Man
ID: 12117136
following jim's idea....give him a ruler and a pencil.....just kidding....Mike
0
 

Author Comment

by:cutemouse
ID: 12117169
lol....

anyway thks

erm...  shanesuebsahakarn, can you give me a full command of Report.Line 1440, 0, 1440, 7200 ? is it Report.Line (1440, 0, 1440, 7200) ?

thks
0
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 500 total points
ID: 12117253
Sorry, it should be:

Report.Line (xTop, yTop) - (xBottom, yBottom)

This can only be used to draw vertical or horizontal lines - if you try to draw a diagonal one, you end up with a rectangle (which might actually be what you need). I haven't tested this though.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now