border style alignment

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

I have a report like following columns and use boder style solid.

Code Description


The problem is when the description has 2 or more lines then the code
still has one line of border.


The first and second column do not have same border height.


Are there any workaround for this?

Your information is great appreciated,
 
iccsi said:
I have a report like following columns and use boder style solid.

Code Description


The problem is when the description has 2 or more lines then the code
still has one line of border.


The first and second column do not have same border height.
Click to expand...


To do what you want, you need to avoid the Border property
and use code in section's Print event to draw the vertical
lines:

Me.Line _

(Me.Code.Left,0)-Step(Me.Code.Width,Me.Section(0).Height),,B
Me.Line _

(Me.Description.Left,0)-Step(Me.Description.Width,Me.Section(0).Height),,B
 
To do what you want, you need to avoid the Border property
and use code in section's Print event to draw the vertical
lines:

Me.Line _

(Me.Code.Left,0)-Step(Me.Code.Width,Me.Section(0).Height),,B
Me.Line _

(Me.Description.Left,0)-Step(Me.Description.Width,Me.Section(0).Height),,B
Click to expand...

Thanks for the informaiton,
It draws a line for the section, but it does not grow with text box.
Are there any way to consider grow text boxes?

Thanks again,
 
iccsi said:
Thanks for the informaiton,
It draws a line for the section, but it does not grow with text box.
Are there any way to consider grow text boxes?
Click to expand...


Arrggghhhh. That should have been:

Me.Line (Me.Code.Left,0)-Step(Me.Code.Width,Me.Height),,B
Me.Line _

(Me.Description.Left,0)-Step(Me.Description.Width,Me.Height),,B

The other way to do this would be to use horizontal line
controls at the top and bottom of the section. Then use the
Line method to draw the vertical lines:

Me.Line (Me.Code.Left,0)-Step(0,30000)
Me.Line (Me.Description.Left,0)-Step(0,30000)
Me.Line _
(Me.Description.Left+Me.Description,Width,0)-Step(0,30000)
 
Back
Top