Report text boxes

Hi Shamini,

Thank you for your post, welcome to the forum.

In answer to your question, you can set the properties of the text box (Control) to Grow and/or Shrink in relation to the amount of text being entered. the Grow and Shrink is only available as an adjustment to the height of the text box not the width.

On your report, change to Design view, right click the control you wish to work on and from the Properties list choose Format, in the list of options find Can Grow and Can Shrink, change these both to Yes and close your Properties list, change back to Print View and observe the field, where text is long Access has wrapped it within the width of the field and changed the height to fit, moving all other records proportionally.

I hope that has helped, regards Pete