Truncation of Memo fields

G

Guest

When I attempt to run a report, I am experiencing an odd problem. My memo
field should post all of my characters. But it will not grow to show the
desired size, regardless of the option I selected in the properties menu.
 
G

Guest

This can happen in both forms and reports if the control bound to the memo
field was entered by dragging from the field list or was created by the form
or report wizard. Delete the control and add a text box control from the
tool box, and set its ControlSource to the name of the memo field.

Ken Sheridan
Stafford, England
 
J

John W. Vinson

When I attempt to run a report, I am experiencing an odd problem. My memo
field should post all of my characters. But it will not grow to show the
desired size, regardless of the option I selected in the properties menu.

In addition to Ken's suggestions (Thanks, Ken, I never knew that!) you should
also *not* set any Format property on the memo field, nor should you sort or
group by the memo field. Any of these operations will truncate it to 255
bytes.

John W. Vinson [MVP]
 

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