Make a text box fit the value inside

[*Glen*]

In my report design view, I have a text box which is filled with blue color.
When I view the report in print preview, the box always remains the same size
depsite the length of characters of the value. I want the entire value to
fit on one line. Values range from two characters to 30 characters in size.
Selecting "yes" for "can grow" or "can shrink" for the text box properties
does not make a difference. Any help is appreciated. Thanks!

*Glen*

 

[Gina Whipp]

Glen,

Check the Detail Section have you set that to Can Grow = Yes? (I am, of
course, assuming this box is in the Detail Section.)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John Spencer]

Can Grow and can shrink control the vertical size. It seems that you want to
control the horizontal size.

Check out Stephen Lebans' site. I think you can use the code in this sample
to control the horizontal size of a control in a report or a form.
http://www.lebans.com/autosize_textbox.htm

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[*Glen*]

Thanks John, you are correct. I'll check it out.

 

[Gina Whipp]

John,

I see I should have read more carefully!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm