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?

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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?

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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> 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?
>

Thanks, Dave. I had already used this option to mark the property to "Move
and Size" with the cells. However, we still appear to have the problem. I
will double check, but am skeptical that this was the problem since this
property was already set.

Thanks,

Richard

************************
"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

Make sure your objects are completely with in the cell or row -- all of it!

Blue Max wrote:
>
> Thanks, Dave. I had already used this option to mark the property to "Move
> and Size" with the cells. However, we still appear to have the problem. I
> will double check, but am skeptical that this was the problem since this
> property was already set.
>
> Thanks,
>
> Richard
>
> ************************
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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

--

Dave Peterson

Thanks, Dave, that could very easily be an issue as the tolerances here are
very close. However, we have snapped the check boxes into the upper left
corner of each cell using the ALT key to constrain the placement. As such,
the object is probably right on the upper and left borders of the cell. If
this is the problem, it would be most disappointing since it, in turn, would
really make proper placement of the check boxes problematic.

Thanks,
Richard

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Make sure your objects are completely with in the cell or row -- all of
> it!
>
> Blue Max wrote:
>>
>> Thanks, Dave. I had already used this option to mark the property to
>> "Move
>> and Size" with the cells. However, we still appear to have the problem.
>> I
>> will double check, but am skeptical that this was the problem since this
>> property was already set.
>>
>> Thanks,
>>
>> Richard
>>
>> ************************
>> "Dave Peterson" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > 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
>
> --
>
> Dave Peterson

Maybe you could try it with a test copy (smaller number of objects) to see if it
helped.

If it did, adjust the real version -- if not, sorry.

Blue Max wrote:
>
> Thanks, Dave, that could very easily be an issue as the tolerances here are
> very close. However, we have snapped the check boxes into the upper left
> corner of each cell using the ALT key to constrain the placement. As such,
> the object is probably right on the upper and left borders of the cell. If
> this is the problem, it would be most disappointing since it, in turn, would
> really make proper placement of the check boxes problematic.
>
> Thanks,
> Richard
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Make sure your objects are completely with in the cell or row -- all of
> > it!
> >
> > Blue Max wrote:
> >>
> >> Thanks, Dave. I had already used this option to mark the property to
> >> "Move
> >> and Size" with the cells. However, we still appear to have the problem.
> >> I
> >> will double check, but am skeptical that this was the problem since this
> >> property was already set.
> >>
> >> Thanks,
> >>
> >> Richard
> >>
> >> ************************
> >> "Dave Peterson" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> > 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
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson