Move text box at runtime

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

I am working on a report that has several sub reports in the
detail section. I have sized the sub reports to have the smallest
height possible in design view. I have set their can grow property to
true so if they have data they will grow vertically as needed.


Here's my problem. Below the sub reports i have a text box. Sometimes
the height of the sub reports is such that the text box that is below
them gets halfway printed on one page and halfway on the other. So I
have tried all kinds of code to measure the height of the detail
section and then move the text box down as needed.


The problem with that approach is only the Print event of the Detail
section can reliably provide the height. By the time the Print event
fires its too late to move the text box down through normal methods
(i.e. textbox1.Top=textbox.Top+100).


So I'm hoping that someone out there has a creative way around the
problem I'm having. I've searched the ng and looked at Stephen Lebans
site and still haven't been able to figure this thing out. I'm sure
its simple but damn if I can figure it out.
 
I'm not sure this will work, but you can experiment.

Add a group to your report based on whatever makes the detail section unique.
Set the group to display the group footer
Move your text box to the group footer
 
Back
Top