Report formatting - Rectangle doesnt grow with fields

Question

Hello,&nbsp;I have a report.text boxes are set to can grow = yesI also have a drawn rectangle that boxes around all the fields in the detail section.&nbsp;Problem:the rectangle doesnt grow when the Beneficiary field grows.&nbsp; Note that the any one of the fields could grow too and not only the beneficiary field.&nbsp;&nbsp;How can I force the rectangle to grow in synch when fields do as well?&nbsp;&nbsp;Not sure if there is a setting for this.&nbsp;&nbsp;&nbsp;below is a screen shot of the issue I am having:Notice the horizontal line near the IBAN field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

george_hepworth · Answer

Tony2021&nbsp;&nbsp;I don't think the rectangle is going to react to the content of a different control. What I think you are seeing, therefore, is expected behavior. The alternative is going to be writing VBA for the On Format event of the report section to calculate how tall the rectangle will need to be and adjust it.&nbsp;Either that or replace the rectangle with a horizontal line below the last control in this section to mimic the look of the rectangle.&nbsp;&nbsp;&nbsp;

karl_donaubauer · Answer

Hi,
&nbsp;
Here's a KB article in the web archive that explains how to program this for lines.
&nbsp;
ServusKarl*********Access-Entwickler-Konferenz: https://www.donkarl.com/?AEKAccess DevCon: http://AccessDevCon.comAccess FAQ: https://www.donkarl.com

arnel_gp · Answer

Tony2021&nbsp;&nbsp;without any Coding you can use the "Gridline Style" of the textbox.change them from Transparent to Solid.you may need to choose the Color of the Gridline also.

tony2021 · Answer

Karl_Donaubauer&nbsp;Hi Karl,&nbsp;thank you for the response.&nbsp; I looked at the code and I was able to replicate but it only draws 1 line to the far right.&nbsp; Do you know how to draw the second line for the left side of the rectangle?&nbsp;&nbsp;

Forum Discussion

Report formatting - Rectangle doesnt grow with fields

4 Replies

Resources