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

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
 
J

John Spencer

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
 
G

*Glen*

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?
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Shrink the Text 1
Can Grow, Can Shrink on a Form 3
How do I set focus (and select text) on a text box on a modeless userform? 0
Make a text box fit the value inside 4
Combo box size in report 2
Make a text box border color change with conditional formatting 12
Maintaining image scale when inserting it into a text box 0

Top