I have a report based on a query. There is a field "comments" that is a memo type however on the report it does not display all of the text. I have the property "Can Grow" set to "yes" however it still only shows partial text. Any ideas? thanks in advance!
Problem with report memo field not displaying all text
- Thread starter Debased
- Start date
Rickster57
Registered User.
- Local time
- Yesterday, 22:38
- Joined
- Nov 7, 2005
- Messages
- 431
Report
Can you post your db?
Can you post your db?
RuralGuy
AWF VIP
- Local time
- Yesterday, 23:38
- Joined
- Jul 2, 2005
- Messages
- 13,819
Hi Debased,
Does the following link shed any light on your problem? http://www.accessforums.net/ftopic5593.html
Does the following link shed any light on your problem? http://www.accessforums.net/ftopic5593.html
Thanks for your replies.
Rickster: I cannot post my database for condidentiality reasons.
RuralGuy: I am looking into the suggestions. The field is included in a totals query and I tried grouping on "First" but no good. I do not sort on it but the post you gave me gave me some other ideas. I will let you know...thanks again...at least I am on the right track with your suggestions.
Rickster: I cannot post my database for condidentiality reasons.
RuralGuy: I am looking into the suggestions. The field is included in a totals query and I tried grouping on "First" but no good. I do not sort on it but the post you gave me gave me some other ideas. I will let you know...thanks again...at least I am on the right track with your suggestions.
I solved the problem by creating a sub report based on the table that contains the memo field and linking it to the id field in the main report. The query for this report is based on many tables and being a "totals" query is most likely the reason the memo field was truncated. Thanks again as your ideas prompeted my solution!
