noe1818 via AccessMonster.com wrote:
I'm not too savy with code, so if you could help me out by explain exactly
what I have to write, I would appreciate it a lot.
You had another post, titled "move from top of page". I wrote the code
that does the connecting of boxes and moving text boxes up and down and
posted it there.
Find my code. Create a new report. Drop 2 text boxes into the Detail
band and 1 line. Name them Text1, Text2, and Line1. Next, drop my code
into the report's code module. Then run.
I set it to 10 up/down levels at 45 twips each. For testing, change the
Me.Text1.Top = (1 * intHeightPerUnit)
Me.Text2.Top = (10 * intHeightPerUnit)
lines. Change the 1 to some other number, the 10 to another and rerun
to see the up down movement and the line connects....and determine what
1 unit of height should be between 2 text boxes.
The 1 and 10 above are values you need to supply in your report.
Bottom line is...most of the code is done for you. I only have 2 text
boxes. You'd have to modify it for more text boxes and change the text
box names.
OnlyTheLonely
http://www.youtube.com/watch?v=IfKmoBYZWz0
>
Salad wrote:
>>>Just a quick question about lines:
[quoted text clipped - 4 lines]
>>>Thanks
Probably write your code in the OnFormat event for the band.
You should be familiar with the Top, Left, Height, and Width properties.
Dim lngNum As Long
lngNum = Me.Text1.Left + Me.Text1.width
Me.Line1.Left = lngNum
...etc
Small Town
http://www.youtube.com/watch?v=wT051lq5Xh0