I have a continuous form and in one of my text boxes I am concatenating data from a one to many relationship to fit into one text box for display purposes only. I have that text box set up to show the data in a column style format. I am having to make the text box on the form long in order to see all of the info that some of the records require. Is there away to change the text box height to fit that particular records data.
So, if I have only one number for that record, the text box would be normal, but if there were 3 numbers the text box would grow to accommodate.
I have seen the code for a textbox to grow, but it doesn’t work in a continuous form style. I have looked at conditional formatting, but have been unsuccessful.
Anyone have any ideas or suggestions. I will do my best to show an example below. Thanks for any help
Record Work Order Title
1 012345 Fix Machine
2 023456, Check Machine and repair
034567,
045678
3 056789 Repair lift
So, if I have only one number for that record, the text box would be normal, but if there were 3 numbers the text box would grow to accommodate.
I have seen the code for a textbox to grow, but it doesn’t work in a continuous form style. I have looked at conditional formatting, but have been unsuccessful.
Anyone have any ideas or suggestions. I will do my best to show an example below. Thanks for any help
Record Work Order Title
1 012345 Fix Machine
2 023456, Check Machine and repair
034567,
045678
3 056789 Repair lift
