Set height of view in split window

[afimike]

Can anyone tell me the vba code to set the height of the bottom pane of a
split window. I tried ActiveWindow.Height = 500, but it changed the whole
window. I tried ActiveWindow.BottomPane., but there wasn't a height
attribute.

 

[John]

Can anyone tell me the vba code to set the height of the bottom pane of a
split window. I tried ActiveWindow.Height = 500, but it changed the whole
window. I tried ActiveWindow.BottomPane., but there wasn't a height
attribute.

afimike,
One quick way to find the code for something is to record a macro of you
doing that operation manually. If it captures some code you're all set.
If not, then there probably is no VBA code equivalent of what your doing
manually.

John
Project MVP

 

[afimike]

John

I did try recording to see if there were any clues. but when I resized the
bottom pane manually, nothing was recorded in the macro. I was hoping that
there was some way to adjust the pane in a split window since you can adjust
the whole window size.


Seems like something that microsoft overlooked or burried deep

thanks
mike

 

[John]

John

I did try recording to see if there were any clues. but when I resized the
bottom pane manually, nothing was recorded in the macro. I was hoping that
there was some way to adjust the pane in a split window since you can adjust
the whole window size.


Seems like something that microsoft overlooked or burried deep

thanks
mike

Mike,
If nothing was recorded, then a straight VBA procedure is not in the
cards. There might be some type of API routine but finding it, if one
indeed exists, might take some time. I checked the following site but
didn't see anything that looked like it would help. But, you might want
to look anyway. The site is:
http://www.mvps.org/access/api/index.html

Anyway, you're welcome.

John
Project MVP