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

Set your detail section to 5 inches and draw a vertical line 5 inches.

Mike

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

(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

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

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.

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

following jim's idea....give him a ruler and a pencil.....just kidding....Mike

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

Thanks, its helpful