How can I make all of my text show in an Access report?

[Kelly R]

My report is very simple: date by month, who is responsible/activity, actual
due date, reference number for another document. This is my first time using
this program and I have kept it very simple and used the wizard to do
everything. I have quite a bit of text that I want to show in the activity
column, but the program wont wrap the text down to a second line, it just
cuts off in the middle of a word or where ever it pleases. It seems
pointless to generate this report if I can't include all of the information I
want and I can't figure out another way to do this. Any help?

 

[Duane Hookom]

Check the datasheet view of the report's record source to make sure all of
the values show up correctly in the query. If all text shows in the query,
make sure the text box in the report and its report section are set to Can
Grow: Yes.

If you can't find the issue, provide us with the SQL view of the report's
record source, the section of the report containing the text box, and Format
property value of the text box.

 

[Marshall Barton]

My report is very simple: date by month, who is responsible/activity, actual
due date, reference number for another document. This is my first time using
this program and I have kept it very simple and used the wizard to do
everything. I have quite a bit of text that I want to show in the activity
column, but the program wont wrap the text down to a second line, it just
cuts off in the middle of a word or where ever it pleases. It seems
pointless to generate this report if I can't include all of the information I
want and I can't figure out another way to do this.

Open the report in design view and double click on the text
box. The text box's property sheet should appear. Select
the Format tab and scan down the list of properties for the
Can Grow and set it to Yes.

Then click on the bar at the top of the section containing
the text box and set the section's Can Grow property to Yes.

Switch the report to preview and see how it looks.

 

[Kelly R]

Thank you Duane and Marshall!! That was way easy! I really appreciate it!