Set height of form?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed from AZ - 10 Jan 2008 21:17 GMT

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

Reply to this Message

Jeanette Cunningham - 10 Jan 2008 21:32 GMT

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

> 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
[quoted text clipped - 10 lines]
>
> Ed

Reply to this Message

Ed from AZ - 10 Jan 2008 21:38 GMT

Beautiful, Jeanette! Thank you!!

Ed

On Jan 10, 2:32 pm, "Jeanette Cunningham"
<n...@discussions.microsoft.com> wrote:

> Hi Ed,
>
[quoted text clipped - 21 lines]
>
> - Show quoted text -

Reply to this Message