Display Memo Field on Report 2

[coco86]

Ok, I give up. What control do I use to display the entire contents of a memo field on a report?

The textbox control is cutting off at exactly 255 characters. (Textboxes don't do this on the form, why do they do it on the report?)



-Coco

 

[GingerR]

they don't have a limit.
do you have Can Grow property set to YES?

 

[coco86]

I do have CanGrow set to yes and it breaks at exactly 255 characters (in the middle of a line no less) That's including spaces and cr/lf (which is two characters)

-Coco

 

[GingerR]

ok, so is your report based on a Totals query where you are GROUPING on the memo field?

 

[GingerR]

coco--if you are using GROUP BY in your query, try using FIRST instead. this will automatically change your field name to FirstOfFieldName, but you can alter that within the query itself by putting the name you want, followed by a colon. pretend your memo field name is Memo, so in your query grid put instead of GROUP BY, put

Memo: Memo
FIRST

ok?

 

[scriverb]

I just created a table, form, and report with a memo field that I have easily 1500 characters typed into it. I can display them on the form and the report without the effect of cutting off at 255. I tried the table alone in the report as well as created a query to display the memo field. Same results. Displays all of the data. Two pages worth of memo field.

I used the drag and drop method of placing the field name from the field list box to the report. Set the Can Grow to Yes. Seems to work fine. I am testing this in A97.

Can't seem to duplicate what you are doing.

Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[coco86]

I'm using Access 2000. The data is stored in SQL Server 7. Neither the report nor the database was originally created by me. No one ever noticed the problem until today, I guess no one ever got wordy enough for it to be an issue.

The CanGrow property is definitely working, it expands enough to show the lines. I tried the drag and drop method and got the same results.

A thought has occurred to me though, now that I'm home and can't test it of course. Maybe the problem is that the report is based on a query and not the actual table?

-Coco

 

[CosmoKramer]

If there is any formatting applied to these controls (such as > for uppercase, etc.), remove the formatting.

 

[scriverb]

Coco, while trying to duplicate it I did use a query and was able to display and print the entire memo field.

Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[GingerR]

again, i wonder if the query is a TOTALS query and there's GROUP BY on it. BOB--try that. i did all the same as you and couldnt duplicate the problem, until i made it a TOTALS query with GROUP BY. that truncated it. i looked around and found similar post on another web site. ended up person there had GROUP BY also. suggestion to change to FIRST works.

g

 

[coco86]

Well, I'm back at work today and was able to check everything and Ginger wins the star.

Changing it to first didn't fix the problem but after looking at the query, it didn't need have any grouping so I just took it off. Problem solved.

Thanks everyone for your help.

-Coco