471,337 Members | 907 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

Missing text from memo field

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

Feb 7 '07 #1
2 6630
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
Feb 7 '07 #2
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
Feb 7 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Ennio-Sr | last post: by
1 post views Thread by barbara_dave | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.