Stretching Form

[Dummy]

Hi,

I have 2 command Buttons under each other in a Form,
I will click the Top Command Button and it will open a subForm between the Command Buttons and Stretch the Form Down, and when i hide the subform, i want to see the 2 command buttons on top of each other again.

Can anyone tell me what shall i do and how many properties i must change?

Thanks a Lot

 

[Groundrush]

Not quite sure what you mean, but will this help at all?


regards
....

 

[Dummy]

Command button i am using shows and hides so it has 2 actions, so similarly they are sorted down each other,

the example u gave is opening the subform in other area which i can do that, but i want to know if the same example u gave can open the subform in the middle of those 2 command buttons and push the second command button to down while stretching the form, and then when i close the subform command button returns to its original position

thanks

 

[Groundrush]

How about this?


regards
...

 

[Dummy]

Thanks alot, this is it

i wanna ask for one more thing, can u try to make ur form smaller then run the form and click the command button to open the subform, and u will notice that the second command button is not appearing, so something to be done also with the main form to strech (showing scroll bars maybe) while the subform is being loaded,
if there is a way

 

[Groundrush]

Thanks alot, this is it

i wanna ask for one more thing, can u try to make ur form smaller then run the form and click the command button to open the subform, and u will notice that the second command button is not appearing, so something to be done also with the main form to strech (showing scroll bars maybe) while the subform is being loaded,
if there is a way

I still dont understand what you are trying to achieve, Why do you need to do this?

The subform does not load it just becomes visible/invisible when activated.

 

[Dummy]

what i will have is a form with maybe 10 command buttons under each other to make subforms visible and invisible, and maybe it will reach a place where the form will be bigger than the screen and there must be stretching of form so that the user scrolls down...thats why i asked from u to make ur form smaller when running to see the consequences....sorry if i was not talking technically about loading or the visibility of the subform, u see my name is dummy hehe
thanks anyways

 

[Groundrush]

No probs....

but be careful with adding too many controls,subforms & things on your main form as it can slow down your database a great deal

regards
..

 

[Dummy]

sorry to bother again, but i guess after checking and realizing that we are using 3 command buttons and playing with the visibility properties, it will be so hard for me to reach what i want to accomplish. since i will use somehow 8 command buttons under each other, and when i click one subform will be visible between them.and one more click back to original place.

what i really want to know is that when i make the subform visible, can i at the same time make the main Form stretch at the same height of the subform? and at the same time pushing down with it all the controls? or shall i ask this in the coding section? or it is impossible to do?

 

[Groundrush]

sorry to bother again, but i guess after checking and realizing that we are using 3 command buttons and playing with the visibility properties, it will be so hard for me to reach what i want to accomplish. since i will use somehow 8 command buttons under each other, and when i click one subform will be visible between them.and one more click back to original place.

what i really want to know is that when i make the subform visible, can i at the same time make the main Form stretch at the same height of the subform? and at the same time pushing down with it all the controls? or shall i ask this in the coding section? or it is impossible to do?

Why don't you add more controls to your form like my example, play around and see what happens, it may not be exactly as you first planned but it may will be close.

as far as I know the main form can not stretch bigger than it is, it will be at its max size like it is when in design mode because of all the imbedded subforms.

but saying that some bright spark will probably turn up and say otherwise...


cheers

 

[___]

Look up...

DoCmd.MoveSize

 

[Groundrush]

Look up...

DoCmd.MoveSize

Hello bright spark, I was just talking about you.....

 

[___]

You must have mistaken me for someone else