Text Box overflowing

[Tracy]

Hi,

I am trying to run a report with a field in it which contains a fair bit of text. On many occasions, the text is truncated. I have set Can Shrink and CanGrow properties to yes, and tried making the field bigger.

Does anyone know if there is a limit on how much text can fit in a text box on a report?

Thanks
Tracy:

 

[vandewi]

Are you actually printing the report? The CanGrow property does not effect a print preview.

 

[3699wat]

A textbox is limited to 255 characters. If you need more space use a memo field. There is code to restrict the size of a memo field if you need to do so.

 

[Tracy]

Thanks.

vandewi: I am not printing the report, just previewing on screen and it still truncates.

3699wat. I am using a memo field in the table, then I create a query from that table, then use the field in the report. It still truncates. Is there any way I can force a txtbox to be a memo field, or should the report just pick up the table field types.

ANy other pointers would be gratefully welcomed.

Thanks for your help.
Tracy