Reports - Row Heights

[Guest]

Hi.
I am creating a report in which I want every column of each row to be the
same height. My problem is this: Each column corresponds to a text field
and thus does not contain many characters (i think 15 max in this case).
However, the last column corresponds to a memo field and is usually quite
longer. I have played around with the CanGrow and CanShrink properties, but
that has not helped. My result is that the row height for the first columns
is small and for the last column is large. Basically, i'd like to create a
spreadsheet type of report in which all column widths and row heights are the
same regardless of text amount. Can anyone help with this??
Thanks. Ryan

 

[Marshall Barton]

I am creating a report in which I want every column of each row to be the
same height. My problem is this: Each column corresponds to a text field
and thus does not contain many characters (i think 15 max in this case).
However, the last column corresponds to a memo field and is usually quite
longer. I have played around with the CanGrow and CanShrink properties, but
that has not helped. My result is that the row height for the first columns
is small and for the last column is large. Basically, i'd like to create a
spreadsheet type of report in which all column widths and row heights are the
same regardless of text amount.

The "row" heights are the same, it's just the text box
borders that are different ;-)

You'll have to make the text boxes BorderStyle Transparent
so they don't get in the way. Then to get the vertical
lines, use the Line method in the detail section's Print
event procedure. Unfortunately, this can get complicated
when a section is split across a page boundary.
Fortunately, Stephen Lebans has worked out all the details
in his PrintLines example database at www.lebans.com

 

[Guest]

Thanks Marshall!!

I've used Stephen's MouseHook fix before and it worked great. I just
started to play around with the PrintLines example that you pointed me to and
it's looking great already.

Thanks a lot for the reply.

-Ryan