Make a text box grow or shrink as you resize a form
When you resize a form, why not take full advantage of the available space? In Access 2007, you can use the anchoring feature to make a control stretch down and across as you make the form bigger, and then shrink as you make the form smaller. Experiment with the available stretching and anchoring options to get the effect you want.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
By default, the controls on a form stay anchored to the upper-left corner of the form, and do not resize when you resize the form. To change this behavior, you can use the Anchoring command. For example, you can configure a text box so that it stretches down and to the right as the form becomes larger. This lets you see more text in the control.
I'm stuck with a form wizard .The tabular format is having a label and associated text box.
If I would shrink the label size then corresponding Text box also shrink.
As I want to shrink or resize only Label field and Text field size remain same
Is there a way to have a text box that will resize itself horizontally depending on the size of the data? The can grow property allows it to grow vertically which I don't want. If there isnot an easy way to do it I would imagine there would be a way to do it with VBcode.
Have set detail.height in OnOpen event of report. Have set Detail to can grow/can shrink. Have set text boxes in Detail section to can grow/can shrink. Have set detail.height in OnFormat event of detail section.
However, after the first time the detail section needs to grow (which it does OK) it does not shrink back for other records displayed in Detail section. LIne height is changing as it should,but not Detail section height.
I've been fighting with this thing for a while, searching all over the internet, and I finally stumbled onto the solution with random clicking
I'm using Access 2010 and I needed a report in my navigation form, but I wanted the user to be able to filter from an unbound text box and click a button to open the report in print preview.
I finally went with a form containing a subreport and the text box and buttons. It worked ok, but the subreport wouldn't grow or shrink.
I finally got it to work by changing the Vertical Anchor property for the subreport control to "Both".
Hope this helps someone out there
does this only apply to BOUND textboxes?
I tried adding an unbound text box (for a compamy name and address) - but it didnt grow with the data.
I found the help a little unclear
Here's another issue with Access 2007. I have a subform that have two group headers; Branch_Name and Commit_ID. The Detail of the subform have four columns; Section (Text), Date Completed(Date), Action Progress (Memo), Action Location (Memo).
The issue that I am having right now is that text that is in the Action Progress field is being cut. I set the Can Grow, Can Shrink of the text box and the Detail as YES and it did not solve the problem.
Then, I set Can Grow, Can Shrink of the text box as YES and NO, respectively, and the Detail as YES for both cases, and it did not solve the problem either.
I have a report that has a "comments" field that can grow. I need to get vertical lines between the headers to form columns. How can I make the vertical lines grow with the fields so that it looks like one continuous line from top to bottom
I have a report where I have several text boxes and Labels that I would like to place inside a rectangle or something similar so that they are enclosed together in the report with a nice border around them and will stay within this border. The rectangle needs to shrink or grow around the labels and text boxes when they grow or shrink
I have an issue that is driving me nuts. I have a report that is printing out what is called a "talker". It prints out in 2 columns and and 2 rows so that is 4 per page. The issue I am having is there is a text box that has information in it. That info is different per "talker" and depending on the length of characters in that text box, I want the font to grow or shrink so that it covers most of that text box. I have tried a few different solutions but nothing is working 100%. If any one has any suggestions, I would be very grateful