textbox that does not display the entire text

[nianko]

Hi,

I have a textbox in a report that is based on the result of a query. I have a "comment" field (type memo) which contains a lot a text (say 10 - 20 sentences). When I run the query, the entire comment is displayed, but when I want to print the report, all the comments are "trimmed" (i.e. only 200-ish characters appear). I tried to look into the different properties of my textbox, but couldn't find anything relevant.

Any idea?

nianko

 

[boblarson]

Is the CanGrow property of both the text box AND the Report's Detail Section set to YES?

 

[nianko]

Yes it is, that's why I'm totally lost !

 

[boblarson]

So you are ABSOLUTELY sure that the entire text is being returned by the query? If the can grow is set right on the report then it is highly likely that the query is really the culprit. If you have included the memo field in the query, that query CAN NOT have ANY criteria on it or it will cause it to truncate.

To get around that, you create one query with the criteria but without the memo field. You then create a SECOND query with that first one and then the table with the memo field and link them either by the primary key or, if it has no primary key, by all fields except the memo field and then include the memo field from it.