How to grow a text box in a continuous form

[darren_access]

I have a parent form that holds contract data and then a sub form that captures sales order entries against the project. There's a notes field in the subform. To start with it is only 1 line deep. Can it be set to expand depth-wise to display all the content after a refresh while subsequent new lines start out at 1 line deep again?

 

[Pat Hartman]

No. Each "row" of the subform is an instance of the subform itself. There is no way for instances to have separate properties. You can teach people to use Shift-F2 to open the zoom box or you can open it progrmatically by adding the command to the double-click event of the text box. Personally, I tend to make all subforms in Data Sheet view. That gives the user the option to make the row bigger (it changes all rows) or smaller depending what he wants to see. The user also gets additional sort and filter options that Access provides automatically very similar to those provided by Excel.

 

[darren_access]

Thank you Pat, that is a great idea.