Lines

[Sr Accountant]

I have a report that has rows/columns and I would like lines separating my
columns and rows for the header and detail. Is there a way to do this
easily, like you can tell Excel to print grid lines? I have tried to draw
lines, but my hands must not be steady enough, as they are never quite
straight enough or long enough, etc...it just does not look good.

Any help would be much appreciated.

Thanks

 

[Duane Hookom]

You can use the Line method of the report in code. This is a bit more complex
than dropping controls on your report.

 

[Sr Accountant]

Can you tell me in code how to do this? I am not familiar with this at all.

Thanks

 

[fredg]

I have a report that has rows/columns and I would like lines separating my
columns and rows for the header and detail. Is there a way to do this
easily, like you can tell Excel to print grid lines? I have tried to draw
lines, but my hands must not be steady enough, as they are never quite
straight enough or long enough, etc...it just does not look good.

Any help would be much appreciated.

Thanks

As Duane suggested, you can use the line method (see VBA help).

However, drawing a straight line using the line control is quite easy.
Hold down the shift key as you drag the line left to right (or top to
bottom). It will be straight.
You can also draw a 'wobbly' line and then set it's Height property to
0" (for a horizontal line), or set it's Width property to 0" for a
vertical line.

 

[Duane Hookom]

Here is some simple code to draw a horizontal line at the bottom of a group
header section.

Private Sub GroupHeader0_Print(Cancel As Integer, PrintCount As Integer)
Me.Line (0, Me.Height)-Step(Me.Width, 0)
End Sub