A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Gap between records in a sub-report using TextHeightWidth mod



 
 
Thread Tools Display Modes
  #1  
Old May 19th, 2005, 11:25 PM
MarkJ
external usenet poster
 
Posts: n/a
Default 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  
Old May 20th, 2005, 01:50 AM
Stephen Lebans
external usenet poster
 
Posts: n/a
Default

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  
Old May 27th, 2005, 06:34 PM
MarkJ
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 07:09 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.