Set height of form?

  • Thread starter Thread starter Ed from AZ
  • Start date Start date
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
 
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
 
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...
 
Back
Top