Dynamically change Detail Section Height

[Philly44]

Ok. Heres thes problem I'm having. I have a report with two text boxes in the detail section. They get there values from a rather large complex UNION query. That all works fine. The problem I have is I need to adjust the hieght of the detail section based on the string in one of the text boxes. Like so:

Information requested 4
-English 2
-French 2

The problem Is I can't just set the height to what I need in design view because it groups everything together. I also can't change the the way the data is passed to it because I need it to follow this order. I have tried doing the formatting in the Detail_Format event but it tells me that the property can't be changed because the print event has already occured. Any ideas would be greatly appreciated, Thank you in advance.

 

[DougP]

Are your text boxes set to "shrink and grow"

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[Philly44]

Yeah I have the properties setup right. The problem is that the report works along the same lines as Continuous forms. So when I try to adjust the height it works with the first peice of data but after that it has run the OnPrint so it won't format anymore. If this can't be solved I found a different format for the report yesterday and so far the poeple are pleased. I would still lke to know how to do tis if you know.