I have enclosed a DB with only the tables associated with the forms. The other tables linked to the forms are not enclosed to make the file light
Views: 0 Size: 63.2 KB">TestDBTotalissue.zip
I wanted total of 2 fields in the footer of the Sub form - SO Value and Weight
The original subform was in datasheet view. The footer was not showing. When I switched the subForm to a continuous form, as I read somewhere, I could see the footer with total fields.
However the function to increase the height of the rows is not functioning. The row height function works in datasheet view. There is one field which is long and I wanted the text to flow down. Somehow the Can Grow configuration does not work and I also tried to change the format using Anchoring. So I used VBA to increase the height and it worked.
In a nutshell
Is it possible to have sub totals in the bottom of the Sub form? If yes now
If continuous form is the only option, how can I get the row height to increase (best it increases automatically based on text length)