Missing text from memo field

[Teresa L]

I am using Access 2003. I have a memo field that I have put into a
report. My problem is that the report will only show a specific
amount of characters in the report. It does not display the entire
field. I have checked the properties and they are set to memo so what
is happening here? I think it is happening in more than one field but
I have only been able to identify or replicate the problem in one
field.

Thanks

[Tim Marshall]

Teresa L wrote:

I am using Access 2003. I have a memo field that I have put into a
report. My problem is that the report will only show a specific
amount of characters in the report. It does not display the entire
field. I have checked the properties and they are set to memo so what
is happening here? I think it is happening in more than one field but
I have only been able to identify or replicate the problem in one
field.

By the sounds of it, there is more text in the memo field of the
record(s) in question than there is space in the control you have set up
in your report. The solution is pretty straightforward.

Assuming your memo fild report text box control is in a detail section,
you need to select the detail section bar and in the detail properties
under the format tab, set "CanGrow" to Yes. You must then ensure you do
the same thing to the Can Grow property of the text box.

You may also wish to consider setting Can shrink to yes as well,
depending on your report layout requirements.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me

[Jens Schilling]

Hi,

I am using Access 2003. I have a memo field that I have put into a
report. My problem is that the report will only show a specific
amount of characters in the report. It does not display the entire
field. I have checked the properties and they are set to memo so what
is happening here? I think it is happening in more than one field but
I have only been able to identify or replicate the problem in one
field.

In addition to what Tim wrote - if your report is based on a query, it's
really possible that your memo field is truncated after 255 characters. This
is often caused by a group statement within a query ( Group by, distinct) -
or by a formatted memo field, as you can read here :

http://support.microsoft.com/kb/259893/en-us

The solution could be to delete the memo field in your original query,
create a second query only containing your ID and the memo field, and
combine it in a third query.

Regards
Jens