allow-a-text-box-to-grow-or-shrink-report-builder-and-ssrs.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.custom
Allow a text box to grow or shrink in a paginated report	Find out how to set property options in Report Builder paginated reports that let a text box expand or shrink based on its contents.	maggiesMSFT	maggies	09/25/2024	reporting-services	report-design	conceptual	updatefrequency5

Allow a text box to grow or shrink in a paginated report (Report Builder)

[!INCLUDEssrs-appliesto] [!INCLUDE ssrs-appliesto-ssrs-rb] [!INCLUDE ssrs-appliesto-pbi-rb] [!INCLUDE ssrb-applies-to-ssdt-yes]

In a paginated report, text boxes aren't just the stand-alone boxes on the report design surface. Every cell in a table or matrix (a tablix data region) also contains a text box, which can be formatted in the same way as stand-alone text boxes. By default, text boxes are a fixed size. You can set options that let a text box expand or shrink based on its contents. These options correspond to the CanGrow or CanShrink properties in the Properties pane.

Allow a text box to grow or shrink

1. Right-click the text box, and select Text Box Properties.

2. Select the General tab.

   • To allow the text box to expand vertically based on its contents, select Allow height to increase.

   • To allow the text box to shrink based on its contents, select Allow height to decrease.

Related content

• Text boxes (Report Builder)