Access 2000_Help with text fields for report.... 1

[jmiranda6sa]

How can you make on a report that contains two text fields side by side, when the "Text Field" on the left side grow, the "Text Field" on the right side grow equal amount. Hopefully you can understand my situation with this description. I'm going to try to post an image to show the behavior of the report.

PS.

Don't know how to post an image, sorry.

 

[dhookom]

I think your question is:
"How do I get the border of side by side text boxes to be the same height when the one on the left can grow larger than the one on the right."

If this is the case, consider using code to draw the borders:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
    Dim dblHeight As Double
    dblHeight = Me.txtLeft.Height
    Me.Line (Me.txtLeft.Left, Me.txtLeft.Top)-Step(Me.txtLeft.Width, dblHeight), , B
    Me.Line (Me.txtRight.Left, Me.txtRight.Top)-Step(Me.txtRight.Width, dblHeight), , B
End Sub

Duane
Hook'D on Access
MS Access MVP

 

[jmiranda6sa]

dhookom,

Thank you for your reply, that code work perfect. I'm really green on VB code and hope that by hanging out in here I can learn a thing or two.

I did notice just one thing, when the text box on the left has one or two lines of text the height is the same between left and right text boxes. But when I have three lines of text on the left text box, the right text box doesn't grow to the same height as the left. The reports looks way more clean now than it did before.

 

[dhookom]

I'm not sure I understand your last paragraph. Are you suggesting the report doesn't look right? If so, set the text box borders to transparent and make sure their tops are aligned.

Duane
Hook'D on Access
MS Access MVP

 

[jmiranda6sa]

What I meant with that last sentence is that the report looks great now compare to what I had before adding your suggestion.