Hi there,
with VBA I would like to dynamically adapt the height of a report's page header depending on the height of a certain text field, which is expandable. The problem is, even though the field is expandable, I always get the same value for textfieldXY.height, no matter how high it is in report view. So I guess that the height value doesn't change depending on the displayed contents. In the end, it's important for me that the detail area below is directly connected to this text field, without any useless space in between.
Can somebody help?? Thanks a lot in advance!! FRANK
with VBA I would like to dynamically adapt the height of a report's page header depending on the height of a certain text field, which is expandable. The problem is, even though the field is expandable, I always get the same value for textfieldXY.height, no matter how high it is in report view. So I guess that the height value doesn't change depending on the displayed contents. In the end, it's important for me that the detail area below is directly connected to this text field, without any useless space in between.
Can somebody help?? Thanks a lot in advance!! FRANK