Data Member Height

[tara99]

Data Member Height doesn't exists.
I can see the WindowHeight or inside height, I can see width, but no height.

Can some one help

[PEB]

Hi,

This concerns what object in Access? Forms, Queries, Reports? Tables?

:)

[MMcCarthy]

Data Member Height doesn't exists.
I can see the WindowHeight or inside height, I can see width, but no height.

Can some one help

Tara

If you're looking to set the form height it is WindowHeight

[tara99]

Tara

If you're looking to set the form height it is WindowHeight

Hi Mmccarthy

what I want to do is to set my form to the full view, I don't want it to changes its lenght when I am going from one form to another.

Any idea how can I do this.

I have this code in my Module

Global FormHeight
Global FormWidth
-----------
for each of the form I have the code below

Private Sub Form_Load()
FormHeight = Me.WindowHeight
FormWidth = Me.WindowWidth
End Sub

Private Sub Form_Open(Cancel As Integer)
Me.WindowHeight = Form.WindowHeight
Me.Width = Form.WindowWidth
End Sub

Still it doesn't give me the full view

regards
Tara

[MMcCarthy]

Sorry Tara,

I have to go back on my previous post as you can only get the windowheight you can't set it. However, this should do what you want.

Private Sub Form_load()

Me.InsideHeight = 10000
Me.InsideWidth = 12200

End Sub

[NeoPa]

Try :-

Private Sub Form_Open(Cancel As Integer)
    Call DoCmd.Maximize
End Sub

Or

Private Sub Form_Open(Cancel As Integer)
    Call DoCmd.Restore
End Sub

to reverse the effect.

[tara99]

Sorry Tara,

I have to go back on my previous post as you can only get the windowheight you can't set it. However, this should do what you want.

Private Sub Form_load()

Me.InsideHeight = 10000
Me.InsideWidth = 12200

End Sub

Is that mean that I won't need the open function?

Also
How can i get the scrollbar disapear from the database window
? is it possible?
cheers
Tara

[NeoPa]

How can i get the scrollbar disapear from the database window?

The scrollbar shows automatically when there are too many items to show in the window at one time.

[MMcCarthy]

Is that mean that I won't need the open function?

Also
How can i get the scrollbar disapear from the database window
? is it possible?
cheers
Tara

I've tested in the on load event and it works find without anything else.

[tara99]

I've tested in the on load event and it works find without anything else.

OK

Thanks