I want to be able to adjust the height of the detail section in a report based on certain conditions. I've tried placing the following code in the report's On Activate event and I've also tried the On Format event in the detail section.

Me.Detail.Height = DetailSize

...where DetailSize is the variable that changes conditionally.

I also changed the Can Grow property of the detail section to Yes but the size does not change from its original setting in properties.

What am I missing?

Thanks

Be your DetailSize is in rasters, eg, inches times 1440.