By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,982 Members | 1,738 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,982 IT Pros & Developers. It's quick & easy.

Data Member Height

100+
P: 106
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
Oct 27 '06 #1
Share this Question
Share on Google+
9 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi,

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

:)
Oct 27 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Oct 28 '06 #3

100+
P: 106
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
Oct 29 '06 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Oct 29 '06 #5

NeoPa
Expert Mod 15k+
P: 31,471
Try :-
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Open(Cancel As Integer)
  2.     Call DoCmd.Maximize
  3. End Sub
Or
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Open(Cancel As Integer)
  2.     Call DoCmd.Restore
  3. End Sub
to reverse the effect.
Oct 29 '06 #6

100+
P: 106
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
Oct 29 '06 #7

NeoPa
Expert Mod 15k+
P: 31,471
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.
Oct 29 '06 #8

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Oct 29 '06 #9

100+
P: 106
I've tested in the on load event and it works find without anything else.

OK

Thanks
Oct 30 '06 #10

Post your reply

Sign in to post your reply or Sign up for a free account.