Gap between records in a sub-report using TextHeightWidth mod

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sub-report that has 2 side-by side boxes that is creating a gap that
varies in size (from non-existent to large) between records. The gap seems
to be proportionate to the number of lines of text that occurs in the boxes.

I think the problem is caused by a module I am using "TextHeightWidth" from
Stephen Lebans (http://www.lebans.com/textwidth-height.htm).

I need the tool however for obtaining the height of the larger of these two
boxes to compare with the height of corresponding row(s) on an additional
sub-report to make the appropriate boxes visible/not visible depending on
which is larger, etc.

Should I scrap using boxes and start over with Stephen Leban's "PrintLines"
tool?

Hope this makes sense. Thanks in advance.
 
Mark the issue is not with my code but your use of it.

Instead of using the PrintLinesClass scroll down to the older non calss
based PrintLines solution. Look at the sample Report that draws a box
around the desired control(s) using the Report object's Line method. Use
this code in the Print event of the relevant section.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Stephen, Using your PrintLines code was a much simpler solution then the way
I was tackling the problem. Thanks for your help.

-Mark
 
Back
Top