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

  • Thread starter Thread starter Kelly R
  • Start date Start date
K

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?
 
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.
 
Kelly said:
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.
Click to expand...

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.
 
Back
Top