Help with report

  • Thread starter Thread starter SF
  • Start date Start date
S

SF

Hi,

I have a report with 2 fields, both are set to RTF. These 2 fields are
placed side by side with the border turn on so that the report would form a
two columns table. When I view it, the result is not what I expected because
line suroundind the field are not showing like a table because of the height
of the filed are not the same.

Is there a way or code to tell Access report to adopt the tallest height (so
that both field are the same height)?

SF
 
SF said:
I have a report with 2 fields, both are set to RTF. These 2 fields are
placed side by side with the border turn on so that the report would form a
two columns table. When I view it, the result is not what I expected because
line suroundind the field are not showing like a table because of the height
of the filed are not the same.

Is there a way or code to tell Access report to adopt the tallest height (so
that both field are the same height)?
Click to expand...


You should use code to draw the rectangles. The usual way
is to use the Print event with something like this air code:

If txt1.Height > txt2.Height Then
Me.Line (txt1.Left, txt1.Top) _
-Step(txt1.Width, txt1.Height), vbBlack, B
Me.Line (txt2.Left, txt1.Top) _
-Step(txt2.Width, txt1.Height), vbBlack, B
Else
Me.Line (txt2.Left, txt1.Top) _
-Step(txt2.Width, txt2.Height), vbBlack, B
Me.Line (txt1.Left, txt1.Top) _
-Step(txt1.Width, txt2.Height), vbBlack, B
End If
 
Back
Top