Is there a way to have a text box in a
report grow horizontally? Everything
I have read about CanGrow talks about
them growing vertically.
You are correct: CanGrow and CanShrink work only "vertically."
It is possible to do some horizontal "rearranging" of Controls from VBA code
(the Left and Width properties are key), but my clients never thought it to
be worth the trouble (cost) of implementing -- we were always able to find
an acceptable format that didn't require such manipulation.
(However, as always, YMMV.)
Larry Linson
Microsoft Access MVP