|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 10th, 2007, 04:42 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Report grid lines
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 
|
|
#2
May 11th, 2007, 01:42 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Report grid lines
johnb wrote:
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. -- Marsh MVP [MS Access]
|
|
#3
May 11th, 2007, 10:34 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Report grid lines
Hi Marshall Look good I'll try it and report back.
johnb "Marshall Barton" wrote: johnb wrote: 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. -- Marsh MVP [MS Access]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
