Gap between records in a sub-report using TextHeightWidth mod

M

MarkJ

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.
 
S

Stephen Lebans

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.
 
M

MarkJ

Stephen, Using your PrintLines code was a much simpler solution then the way
I was tackling the problem. Thanks for your help.

-Mark
 

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