Help with report

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
 
M

Marshall Barton

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)?


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top