If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Gap between records in a sub-report using TextHeightWidth mod
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. |
#2
|
|||
|
|||
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. "MarkJ" wrote in message ... 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. |
#3
|
|||
|
|||
Stephen, Using your PrintLines code was a much simpler solution then the way
I was tackling the problem. Thanks for your help. -Mark |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |
Generating Individual Records in a Report | Paul | General Discussion | 1 | August 11th, 2004 06:42 AM |
Displaying null records in a a report | Scott | Setting Up & Running Reports | 1 | August 9th, 2004 08:47 PM |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |
Report prints additional page with no records | Nelson | Setting Up & Running Reports | 1 | June 30th, 2004 09:04 PM |