If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Controls collapsed with outline
We have a problem with a column of checkbox controls linked to cells. When
a group of rows is collapsed using the outline feature, the controls in the collapsed portion of the column are eventually all stacked on top of each other. Then, when the outline is re-expanded, the checkbox controls are no longer on top of the cell they were linked to in the column before collapsing the outline. Instead, the whole group of controls is stacked over a single cell at the bottom of the collapsed section. How do we link the controls to the cells so that they will reappear over the proper cells when the outline is expanded? |
#2
|
|||
|
|||
Controls collapsed with outline
Right click on the Checkbox and choose "Format Control" and then the
"Properties" tab for 3 options. -- Regards Dave Hawley www.ozgrid.com "Blue Max" wrote in message ... We have a problem with a column of checkbox controls linked to cells. When a group of rows is collapsed using the outline feature, the controls in the collapsed portion of the column are eventually all stacked on top of each other. Then, when the outline is re-expanded, the checkbox controls are no longer on top of the cell they were linked to in the column before collapsing the outline. Instead, the whole group of controls is stacked over a single cell at the bottom of the collapsed section. How do we link the controls to the cells so that they will reappear over the proper cells when the outline is expanded? |
#3
|
|||
|
|||
Controls collapsed with outline
If you used checkboxes from the Control toolbox toolbar, you can:
rightclick on each Choose Format Control Then on the Properties tab, select move and size with cells If you used checkboxes from the Forms toolbar, you're out of luck. Maybe you could replace them with checkboxes from the control toolbox toolbar. (or write a macro that hides the checkboxes, then hides the row????) Blue Max wrote: We have a problem with a column of checkbox controls linked to cells. When a group of rows is collapsed using the outline feature, the controls in the collapsed portion of the column are eventually all stacked on top of each other. Then, when the outline is re-expanded, the checkbox controls are no longer on top of the cell they were linked to in the column before collapsing the outline. Instead, the whole group of controls is stacked over a single cell at the bottom of the collapsed section. How do we link the controls to the cells so that they will reappear over the proper cells when the outline is expanded? -- Dave Peterson |
#4
|
|||
|
|||
Controls collapsed with outline
Thanks, Dave. I had already used the "Format Control" option to mark the
boxes to 'Move' with cells, but still seem to have the problem. Thanks, however, for the suggestion, I will double check just to make sure. Thanks, Richard ********************* "ozgrid.com" wrote in message ... Right click on the Checkbox and choose "Format Control" and then the "Properties" tab for 3 options. -- Regards Dave Hawley www.ozgrid.com "Blue Max" wrote in message ... We have a problem with a column of checkbox controls linked to cells. When a group of rows is collapsed using the outline feature, the controls in the collapsed portion of the column are eventually all stacked on top of each other. Then, when the outline is re-expanded, the checkbox controls are no longer on top of the cell they were linked to in the column before collapsing the outline. Instead, the whole group of controls is stacked over a single cell at the bottom of the collapsed section. How do we link the controls to the cells so that they will reappear over the proper cells when the outline is expanded? |
Thread Tools | |
Display Modes | |
|
|