My team has given me a challenge that I am struggling with. I have a Form that contains a tab control and sub-forms on the pages of the tab control. My Challenge is with one of the sub-forms that is a continuous sub-form. In the table each record shows the Subproject, Phase, and amounts by year (10 amount columns that the users enter their budget numbers into). The data looks like the Original Budget Data jpg attachment
When I put the data into the form it looks like the Current Form View jpg attachment
The team wants to be able to save space on the form by only showing the Subproject with the Planning Phase and only showing the Assumption field only after the Const/Close Phase. See Sample Desired Form View jpg
I know that I can do this on a report and I have explained the challenges of this being a form and not a report and that grouping does not work in this view. Based on this conversation they asked to hide the Subproject unless the Phase is Plan and hide the Assumption unless the phase is Const/Close. I know that hiding the data does not make the field smaller and save the space they want to save. Is there a way to accomplish what my users want? Can you point me in the right direction?