Can Grow

[SMERTZ]

How can I make a notes field in a report based on a query automatically grow
to allow all notes to fit into a report? Currently the report cuts off the
notes field based on how I adjust the field in report designer. I have set
the can grow option to "Yes" but does not seem to matter.

 

[Rick Brandt]

How can I make a notes field in a report based on a query automatically grow
to allow all notes to fit into a report? Currently the report cuts off the
notes field based on how I adjust the field in report designer. I have set
the can grow option to "Yes" but does not seem to matter.

You also need to set CanGrow for the report section to Yes.

 

[SMERTZ]

When you say section, I assume you mean the "Detail" section as that is
where the field is. IF so I did that and still get the same results.

 

[Guest]

How can I make a notes field in a report based on a query automatically grow
to allow all notes to fit into a report? Currently the report cuts off the
notes field based on how I adjust the field in report designer. I have set
the can grow option to "Yes" but does not seem to matter.


If your report is based on data from a table, make the field containing your notes a "memo field" In the design view of the report, right-click on the control-source box and type yes in the can grow option.

Let me know if this helps.

 

[Rick Brandt]

When you say section, I assume you mean the "Detail" section as that is where
the field is. IF so I did that and still get the same results.

So if you set the vertical size of the TextBox to zero you see nothing in the
resulting report?

This is a TextBox you are using right?

 

[SMERTZ]

No, this is a memo field

So if you set the vertical size of the TextBox to zero you see nothing in
the resulting report?

This is a TextBox you are using right?

 

[SMERTZ]

Both the field properties of the memo field placed on the report, and the
detail section of the report have "Can Grow" set to yes, and it still does
not grow to allow all notes to fit in the printed report.

 

[Rick Brandt]

No, this is a memo field

I wasn't asking about the DataType. I was asking about the kind of
*control* you are using on the report to display the field.

 

[Rick Brandt]

Both the field properties of the memo field placed on the report, and
the detail section of the report have "Can Grow" set to yes, and it
still does not grow to allow all notes to fit in the printed report.

Are you sure the issue is "growing/shrinking" and not truncation?
Truncation of memeo fields can be caused by several things as well (applying
formatting, grouping in the query, etc.).