Can Grow

S

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.
 
R

Rick Brandt

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

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

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.
 
S

shooter

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

Let me know if this helps.
 
R

Rick Brandt

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

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?
 
S

SMERTZ

No, this is a memo field


Rick Brandt said:
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?
Click to expand...
 
S

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.
 
R

Rick Brandt

SMERTZ said:
No, this is a memo field
Click to expand...

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.
 
R

Rick Brandt

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

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