Field not growing on report

[matriks]

I have a table with a field that I have set the Data Type to Memo. When I pull that field into a report, it seems to be treating the field as a Text Data Type and is not pulling in all the data entered. Is there something here that I'm overlooking?

 

[David R]

Did you set Can Grow/Can Shrink for the field?

 

[matriks]

Yes, Can Grow and Can Shrink both are set to yes.

 

[Rich]

Is the report based on a query, if so what type?

 

[matriks]

The report is built from a simple query.

 

[Rich]

Does the query display the entire contents of the field?

 

[matriks]

Yes - when I run the query, the entire contents of the field show up when I run the query itself.

 

[torok]

Same problem here

I just ran into exactly the same problem, only I'm using my table as a datasource. I have a memo field that seems to have all the data in the table, but even though the grow/shrink properties of the textbox on the report are set to TRUE, it seems to only grow enough to show (#lines - 1), no matter how big or small I make it. It's very frustrating.

If I make it huge, it'll even shrink so that only (#lines - 1) is shown on the report!

Anyone have any more ideas?

 

[torok]

Actually, I found a workaround. Turns out if you specify a line spacing in the control, Access chooses to discard the last line in the field. Not very convenient, IMHO, but as long as you put the line spacing to 0" it all shows up.