expand text box in report to fit text

[marla]

Hi,
I feel like my problem is simple but I just can't figure
it out. I have Access 2002. When I create a report, some
of the fields will expand to include all text typed in;
others won't so some of the text gets cut off and doesn't
show up on report. I can't figure out how to get all the
text to show, to get the text box to size itself to
however much text is in it.

I thought maybe it had to do with if the field was "text"
vs "memo", but when I went back and changed them all
to "memo" it didn't solve the problem.

Thanks for any help you can give---Marla

 

[mark]

In the properties list for the text field on your report,
set Can Grow = Yes.

 

[Rick Brandt]

Hi,
I feel like my problem is simple but I just can't figure
it out. I have Access 2002. When I create a report, some
of the fields will expand to include all text typed in;
others won't so some of the text gets cut off and doesn't
show up on report. I can't figure out how to get all the
text to show, to get the text box to size itself to
however much text is in it.

I thought maybe it had to do with if the field was "text"
vs "memo", but when I went back and changed them all
to "memo" it didn't solve the problem.

TextBoxes have a property called CanGrow. Set that accordingly.