Make a text box expand or shrink based on size of the value

  • Thread starter Thread starter *Glen*
  • Start date Start date
G

*Glen*

I am working on a report in design view. Is there a way to have a text box
get longer or shrink according to the value? For example, one of the headers
is "Operations" while another header is "Resource Integration."

***Since the text box has a blue fill, there will be empty space within the
text box if I make it large enough to fit the longest word. Therefore, I
want the text box to expand or shrink as necessary.

Any input is appreciated. Thanks!

Glen
 
You can check out the following site
www.lebans.com

If there is a way to do what you want there will be an example on that site.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
For the text box, 'Can Grow' and 'Can Shrink' are both set to Yes. The field
does not widen; instead, the words wrap and the field height expands. Can I
make the length of the field expand so the entire phrase is on the same line?
 
Can I make the length of the field expand so the entire phrase is on the
same line?
Open in design view and drag the right side as wide as you need it.
 
Back
Top