create a vertical line in reports

  • Thread starter Thread starter Kitty
  • Start date Start date
K

Kitty

can anybody show me how to create a vertical line fm the top margin to the
bottom margin? thx
 
In the Page event procedure of the report, use the Line method.

This example draws a red line from the top margin to the bottom margin, at
the left margin:

Private Sub Report_Page()
Me.Line (Me.ScaleTop, Me.ScaleLeft) - (Me.ScaleTop, Me.ScaleHeight),
vbRed
End Sub
 
At last you resolved the problem how to draw a vertical line 10 cm from the
margin. Please be kind and let us know how you did it so we can benefit too.
Mansoor
 
There are 1440 twips to the inch, and 1 inch = 2.54 cm.
10cm in twips is: 1440 * 10/2.54 = 5669

To draw a red line 10 cm from the left margin would be:

Private Sub Report_Page()
Me.Line (Me.ScaleTop + 5669, Me.ScaleLeft) - _
(Me.ScaleTop + 5669, Me.ScaleHeight), vbRed
End Sub
 
Thank You, Mr Browne
Mansoor

Allen Browne said:
There are 1440 twips to the inch, and 1 inch = 2.54 cm.
10cm in twips is: 1440 * 10/2.54 = 5669

To draw a red line 10 cm from the left margin would be:

Private Sub Report_Page()
Me.Line (Me.ScaleTop + 5669, Me.ScaleLeft) - _
(Me.ScaleTop + 5669, Me.ScaleHeight), vbRed
End Sub
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drawing Vertical Line 2
Print Vertical Line 1
Vertical lines and grid 10
Vertical Text Rotation 5
Reports in Access 2
Add vertical lines on mirrored margins in word 2007 7
Auto set height of vertical line to height of detail section 1
Grow Vertical Line 11

Back
Top