[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

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

Posted on 2004-09-21
9
Medium Priority
?
1,125 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 66

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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 

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
 
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 66

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 2000 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

590 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