Reports - Row Heights


G

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
 
Ad

Advertisements

M

Marshall Barton

Ryan said:
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
 
Ad

Advertisements

G

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
 

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

Similar Threads


Top