Label and Control distance

[JonathanT]

Is there a way to set the horizontal distance between a label and control besides dragging the anchor? I need to have a very specific distances between the two and I have a large number of labels/controls.

[CJ_London]

if not already done, select all the labels, delete and then paste to disconnect them from the controls

size and position the top label and control as required

Then select all the labels and on the arrange tab, use the size/space tab to align and set width as required.

Repeat for the other controls

[JonathanT]

Thanks CJ, that works. I was hoping there was a property I could set to define the distance between a control or label since the distance between the label and control will vary

[CJ_London]

not so far as I am aware - but you can write vba code to position controls as required - that can either be fired in the form open event, or you can use code to create your form with everything positioned as required. Whether it is worth it depends on you - probably not worthwhile for a one off alignment