Editable AND grow/shrink?

[fhickler]

Access non-expert here, so sorry if this is a newbie-ish question.

I have a simple relational database with 2 tables, each record in Table A relates to many records in Table B. I have a master form that has both tables next to one another, related via a master text field. You select a record in Table A and all the related records display in Table B. So far so good. One of Table B's fields is a multi-line text field. I want that field to grow/shrink depending on the amount of text in it, and I also want to be able to edit the field.



If Table B is inserted into the master form as a subform, the field can be edited, but cannot grow/shrink - my understanding is that is not possible on subforms. If it is inserted as a sub report, it can grow/shrink, but cannot be edited - again, my understanding is that subreports cannot be edited.

Is it possible to somehow have the best of both worlds, with editable text fields that also grow/shrink?

[June7]

Controls don't grow/shrink on forms. That is what reports allow for. Textbox on form will have vertical scroll bar.

What do you mean by 'multi-line' text field? Textbox set to generate new line with ENTER key?

[CJ_London]

Grow/shrink only works on print and print preview - including forms

if this is standard form view you would need code to change the height - in the form current and perhaps the control change or after update event where you calculate the height required and adjust the top position of any control below the control you want to adjust

edit - note in a continuous form , this adjustment would affect all rows

have you considered using the zoom box for adding/editing data?

[June7]

Actually, also works in Report View. Which is how a report would display when installed on a form.

[fhickler]

I thought I'd clarify my question with a screenshot. This is a form with a subform on the left, based on table A, which is a table of rooms/equipment (ignore the colors and boxes, etc - just think of it as a normal table). To the right of that is a subreport based on table B, which is a related table of notes for each record in table A. To the right of that is a subform, also based on table B. When I select a record in table A, it shows me all the related notes records for that room/piece of equipment. So far so good. Here is the issue: the subreport has text boxes that grow and shrink nicely, but cannot be edited. The subform has text boxes that can be edited, but don't grow/shrink. What I would like is a way to have the notes show up in such a way that they can be edited AND will grow/shrink. Is there any way anyone can think of to achieve this?

[CJ_London]

Think we all understand what you are trying to achieve - and it’s not possible

only way would be edit is to use a pop up form that can sized to match the position and size of the selected record, populate with the text then save and update the record based in some event. Can be done but requires a lot of code and does not really work the way you would want

[fhickler]

That actually gives me a couple ideas that I might play around with. Thanks.

[fhickler]

That actually gives me a couple ideas that I might play around with. Thanks.

I decided to display the report with edit buttons, as is explained in this video:
https://www.youtube.com/watch?v=W2h6qYlTDHE