Make a text box grow or shrink as you resize a form
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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.
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 not modified the subform or anything else. This is my calculation: =[Child562].[Form]![txtItemValueCalculation]
If I move or resize the text box and then select View Form it works, but once I close the database and reopen it, it does not work.
The text box shows the following error in it:
I'm trying to make a sub-report to list the contents of a field separated by commas, such as: Abcd, 12345678901234567890, 1234567890.
Basically, I want the contents of that field displayed in a sentence-type fashion, separated by commas.
I've tried a 5 column report that goes Across the page, but the length of our data varies from 4 characters, to about 100 characters. A list of all the data is what I'd like to get.
The fields are able to "grow" however the "grid" loses it's formating when one fields grows and the others stay the same.I have set all the fields to grow, didn't work. I though maybe by grouping all the field together they would be forced to grow to the largest field but there doesn't seem to be an option for this?
My control source is "Patients Detail Form"
My control is MedicareNo.
In design view I create a form using Form Design, I add in a text box and under Properties, Control Source, I add the following
=[Patient Details Table]![MedicareNo]
When I go to Form View,
I thought I could get around the problem by selecting Form (on create tab), and letting Access make the form automatically, which it did, and when I went to Form View, I was able to put in data without getting the #Name? error. However, when I went back to change the design of the form :
I tried to make a text box smaller, and all the text boxes in the form adjusted, I was not able to select only one for resize.
I was able to move text boxes up and down (to change the order), but was not able to move text boxes next to each other (
I know there is the "Can Grow" property, but that only seem to work vertically, not horizontally. Is there another way I could dothis?