Shift Buttons up when textboxes are hidden.

[gammaman]

Is there a way either through form control settings or VBA that I can shift buttons upwards or downwards based on whether other text boxes are visible or not?

In the attached image image, If I hide (using VBA) the circled items, I would like to shift the buttons upwards under the first row that would still be visible. Likewise, if I unhide a row (add line) then the buttons would shift downwards.



Or should I use another approach all together?

[CJ_London]

it can be done in vba, but wouldn't it be easier just to put the buttons at the top?

Assuming this is not a continuous form, then in vba you would set the top position of the buttons depending on how many rows were visible.

[gammaman]

Thanks. Good Idea!.

[June7]

I would position the buttons above or not even be concerned about the empty space. Your code will have to reposition the buttons as each 'row' is revealed.

Suggest you consider using the & shortcut. Place an & in front of a character in the button caption and this will allow Alt+letter shortcut keys. I like to design forms so users don't have to mouse.