Set height of form?

E

Ed from AZ

I'm new to Access VBA. I'm trying to set the height of the form when
it loads. I have controls farther down, but I don't want the form to
show everything unless the user needs those other controls. I set
CanGrow to No and put in this code:

Private Sub Form_Load()
Me.Detail.Height = 1440
End Sub


But the form loads with its full height displayed.

How can I accomplish this?

Ed
 
J

Jeanette Cunningham

Hi Ed,

Try using
DoCmd.MoveSize
If you put the cursor in MoveSize and press F1, the help will explain what
to do.

Jeanette Cunningham
 
E

Ed from AZ

Beautiful, Jeanette! Thank you!!

Ed


Hi Ed,

Try using
    DoCmd.MoveSize
If you put the cursor in MoveSize and press F1, the help will explain what
to do.

Jeanette Cunningham









- Show quoted text -
Click to expand...
 
Top