How to do automatic resizing of Textbox based on their content

Use the Can Grow and Can Shrink properties with Textbox report items. This will grow and shrink Textbox height vertically based on their content.