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 -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top