nathan.malone
New member
- Local time
- Today, 11:27
- Joined
- Apr 5, 2018
- Messages
- 6
I have an MS Access report with a detail section that automatically adjusts its height to fit its contents using the CanGrow and CanShrink properties. The report is about ongoing projects within the company, and the height of the detail section can fluctuate substantially for each project. Additionally, there are two versions of this report: general and administrative. The administrative version has some information that the general version does not have, which causes height differences for the same projects between the two versions. My current task is to make the height of the detail section for each project match between the two versions of the report, even if the contents don't match.
My current idea to approach this problem is to record the height of the detail section of each project on the administrative report, then run the general report and set the height of each detail section to match the recorded heights from the administrative report. To do this, I have to determine the height of the detail section AFTER the section has automatically adjusted its height, which is the keystone that I cannot figure out. The reason that I put emphasis on the word "after" is that, in my experience, the Detail.Height property during the Detail.OnFormat event does not reflect the height of the detail section after the section adjusts to fit its contents, but rather it reflects the height of the detail section before it adjusts to fit its contents (effectively giving me the height that I assigned to it in design view).
I have been beating my head against the wall with this problem for far too long. How do I get the height of the detail section after it has automatically adjusted to fit its contents? Alternatively, is there a better approach to making the corresponding detail sections between the two report versions match in height?
My current idea to approach this problem is to record the height of the detail section of each project on the administrative report, then run the general report and set the height of each detail section to match the recorded heights from the administrative report. To do this, I have to determine the height of the detail section AFTER the section has automatically adjusted its height, which is the keystone that I cannot figure out. The reason that I put emphasis on the word "after" is that, in my experience, the Detail.Height property during the Detail.OnFormat event does not reflect the height of the detail section after the section adjusts to fit its contents, but rather it reflects the height of the detail section before it adjusts to fit its contents (effectively giving me the height that I assigned to it in design view).
I have been beating my head against the wall with this problem for far too long. How do I get the height of the detail section after it has automatically adjusted to fit its contents? Alternatively, is there a better approach to making the corresponding detail sections between the two report versions match in height?