Microsoft Access: Long Text field truncated in report! How to fix this?

Question

I created a simple report in Access. One line per record (using the default tabular format with Report Wizard). However, one text field is sometimes too long and is truncated when one record is displayed on only one line.

How do I tell Access that when the text field is too long, display it (and the record) in more than one line as needed so that the complete text is shown? Thanks.

More info: I tried to increase the height of the text field, but then every record in the report had its height increased whether needed or not. This wasn't what I wanted.

Answer 1

Set the CanGrow property of the text field to True.
This will increase the field height only in the lines where it's really necessary.

Answer 2

Quoted from MS Office Support Documentation [Refer the part Change the field size of a text field]

1. Right-click the table that contains the field that you want to change, and then click Design View.
2. In the table design grid, select the field for which you want to change the field size.
3. In the Field Properties pane, on the General tab, enter the new field size in the Field Size property. You can enter a value from 1 to 255. This number specifies the maximum number of characters that each value can have. For larger text fields, use the Memo data type.