expand text box in report to fit text

  • Thread starter Thread starter marla
  • Start date Start date
M

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
 
marla said:
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.
Click to expand...

TextBoxes have a property called CanGrow. Set that accordingly.
 
Back
Top