Hello,

I cannot figure out a way to use form controls within grouped sections without the controls bunching up when the group is collapsed. I saw a post from 2011 where someone seemed to be asking the same question but there were no responses, so hopefully someone is able to help or offer an alternative solution. I can share the file if someone thinks they have a solution.

A little background on why this is needed:

I'm trying to develop an new audit form for my work of which it's ultimate purpose is to be printed out and hand-marked by the auditor. The form is a supplement indicating specific project features that the auditor needs to look for within the audit package documents. Projects vary between a few main categories of scope and each category has sub-sections that may or may not apply to that project. The current form is a Word Doc table (not designed by me) and its major flaw is that any category not applicable to that project is just left blank and is a waste of paper/ink. This is especially true when only a small category applies and then there are several pages that are just wasted.

So my solution to this is to use the grouping feature which I've found to be mostly successful. My excel form is about 4 pages long when fully expanded, but when collapsed to one small section, fits on 1-2 pages. However, there is a major snag - all of my form controls bunch on top of eachother when I collapse the areas. If need be, I'll just have to take out all of the form controls I guess, but I'd really rather keep them since most of the form is standard options to select from and just a few fill-in-the-blanks.

I appreciate any suggestions! Thank you!

- Jillian