Variable row height in Report Detail Section

[michael_folsom]

In the detail section of my report, I recently added a second row which has only 1 text field. When the value of the textbox in the 2nd row is null, I want the total row height equal to just the first row. When the value in the textbox in the 2nd row is not null, then the total row height is equal to row 1 and 2. I tried to make the textbox in the second row invisible when it had a null value thinking that when it was null, the report would shrink to the first row height, but that didn't seem to work. I am only a beginner with VBA, but any suggestions are appreciated.
Thanks

 

[David R]

You shouldn't need VBA for this. Explore the CanGrow/CanShrink properties of the fields in question, and also for the form itself (Detail).

One thing to be aware of is that overlapping fields will have a tendency not to shrink properly. A tiny bit of vertical whitespace will fix that.