Report grid lines

[Guest]

Hi Guys

I have a less than straight forward group of line grids on a Form and
Subform. I currently use Me.Line (851, 2700)-Step(0, 1440), vbBlack to fix
the horizontal or vertical lines where I want them. Its crude. Its clunky but
it works fine. That is until I move a control then I have a real mess. What I
need to be able to set the horizontal and vertical lines relative to say the
controls Left or Top property. Any suggestions??

regards johnb

 

[Marshall Barton]

I have a less than straight forward group of line grids on a Form and
Subform. I currently use Me.Line (851, 2700)-Step(0, 1440), vbBlack to fix
the horizontal or vertical lines where I want them. Its crude. Its clunky but
it works fine. That is until I move a control then I have a real mess. What I
need to be able to set the horizontal and vertical lines relative to say the
controls Left or Top property. Any suggestions??

Use:
Me.Line (c.Left,c.Top)-Step(0,c.Height)
for a vertical line on the left side of the control c.

Me.Line (c.Left,c.Top+c.Height)-Step(c.Width,0)
for a horizontal line under the control.

If the section can grow/shrink and you want a vertical line
to go from the top of the control to the end of the section:
Me.Line (c.Left,c.Top)-Step(0,32000)
This works because the line will be clipped at the section
boundary.

 

[Guest]

Hi Marshall Look good I'll try it and report back.

johnb