I am using MS Access 2003 to genereate a report. The report has a sub-report on which I have two fields. The first field contains a number and the second some text. In those cases where the text runs onto a second line I would like to adjust the height of the first text box to match.
I tried adding firsttext.height = secondtext.height in the Detail Format section of the subreport but it does not make a differerence.
I then checked the Detail Print section and at that point the height of the secondtext.height registers the fact that the text box has grown but I cannot adjust the height of the firsttext since the printing has already started.
Does anyone have a solution to this problem. I have attached a screen shot which shows how the report currently looks.