Make a text box fit the value inside

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

*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*
 
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
 
Back
Top