Center an item in a form with VBA

[Huey462]

I have a background form (cleverly called "Background") that has a button on it to open the control panel if the end user manages to somehow close all of the other windows. Is there a way to have access automatically center this button after the form is maximized?

The reason I want to do this is that the control panel Modal is set to “Yes”, making the button on the background form unclickable, if I can “hide” it behind the other form by centering the button it would alleviate some why can’t I click this questions.

 

[dhookom]

To center the command button left to right, add this code to the form's resize event:

Private Sub Form_Resize()
    Me.Command0.Left = (Me.InsideWidth - Me.Command0.Width) * 0.5
End Sub

Duane
Hook'D on Access
MS Access MVP

 

[Huey462]

Exactly what I needed.

Thank you very much