Change top of each control

[AmanKaur123]

Hi All



I have a Box with the checkboxes and labels. All of them have Tag "B" but now my question is if I want to move the top of each of these bit up then how this can be done? I want to move the position of that box with the checkboxes. If I write the following code then the top property doesn't work :

For Each ctr In Me.Controls
    If ctr.Tag = "B" Then
       ctr.Visible = True
      ctr.top=????         ' I can see TopPadding option instead
    End If
Next ctr

Any help will be much appreciated.

Thanks

[ranman256]

why wouldnt you set .TOP in design mode?

[AmanKaur123]

This is because based on the options selected I have to make the controls invisible or visible and move the position(Top) of them .

[AmanKaur123]

any help on this guys???

[aytee111]

Why not make them enabled/disabled instead, they will be grayed out and the form will not need to be redesigned all the time.

[AccessPower]

Have to tried to use the top property as you have it now? Just because you don't see it doesn't mean it won't be available. Also, if you're looking at getting a value for top, you can always get the current value to see how it is formatted by using debug.print ctr.top. Access assigns an inch value to 1440 in VBA for a few properties. Not sure if it works for the top property too.

[AmanKaur123]

Thanks Accesspower. I will try it

[Missinglinq]

If you created the Form using the Wizard, the Controls are all 'connected,' if you will, i.e. one Control cannot be moved around independent of the other Controls, and this may be the problem, when trying to position a given Control. In Form Design View

1. Select all Controls in the Detail Section of the Form
2. Click on the Arrange Tab on the Ribbon
3. Click on the Remove Icon
4. Try moving the Control now

Linq ;0)>

[Micron]

To answer your question about not seeing .Top:
Not all properties or methods are shown by Intellisense when you declare a control as an object. I suspect you dim'd ctr although you don't show that.
To verify, type Me.txtNameOfControl. and Top should show in the list. I supposed the reason is that the MS decided to put what db designers would most likely need in order to keep the list from being huge. Probably a good decision.

If your controls are not part of a group as Missingliq is thinking, your way should work. And yes, the vba value is in twips (roughly 1440 per inch).