Expandable Text Boxes

[Jake]

Is it posible in an access report to make a text box (or something similar)
that will expand downward to accomodate the size of its value?

I have a memo field that I would like to include in a report and the size of
its contents vary widely. If I make it small it gets cut off and if I make it
large there is a lot of wasted space.

Any sugestions?

Jacob

 

[Marshall Barton]

Is it posible in an access report to make a text box (or something similar)
that will expand downward to accomodate the size of its value?

I have a memo field that I would like to include in a report and the size of
its contents vary widely. If I make it small it gets cut off and if I make it
large there is a lot of wasted space.

Try setting the text box And its section's CanGrow property
to Yes

 

[Jake]

Marshall,

That worked wonderfully, thank you.

Jacob