Losing view of a label and box when changing their width property on Form On_Open event in Access 20

[Tim]

Have a box for background color, formatted to the Back in Design View, and
several labels on top of it in the Header section. The last two columns are
not
visible unless a specific type of data is present. Works fine but I'd like
to make the box and the title label smaller in Design View so that there
isn't a
lot of blank background color showing when those columns aren't
needed. It would just make the form look a little neater, sized to the
column labels present, instead of the big blank unused space.

Set the width property of the box and title label controls to a smaller size
in Design View. Change
the Width property to a larger size for each in the Form Open event when the
data is present.
The problem is that the box and title label no longer show on the form at
all. The unmodified
column title labels that should be in front of the box are still there just
no colored background and not title label.

I've tried using RunCommand acCmdSendToBack but that is not available in the
Form View, didn't think it would be but tried anyway. I've looked at several
of the DoCmd methods, e.g. DoMenuItem, but if any of these or the RunCommand
methods apply I've been unable to get them to work.

Any help would be appreciated.

 

[Clif McIrvin]

Tim, there's a lot more traffic in microsoft.public.access ... there's a
lot of coding Q&A there regularly.