Size of memo contro on report

T

Tony Williams

I have a field which is a Memo type and is used as the control source of a
control on a report. The Can Grow property of the control is set to Yes but
the control still doesn't show all the data in the field when the report is
produced. The same thing happens on a form which uses the same field as the
control source on a control on the form. is this because I'm using a memo
field and how can I make sure that all the data in the field is shown on the
form and reports. I've used a memo type for the field as I cannot restrict
the user to 255 characters for this particular field.
Thanks
Tony
 
A

Allen Browne

Make sure you have set the Can Grow to Yes for the (Detail?) section as well
as the control.

If it is truncating at 255 characters, it may be one of the issues listed
here:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html

You won't be able to get controls growing in the form.
 
T

Tony Williams

Thanks Allen I'll go through my report and form and look for those
suggestions
Tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top