How to expand a form?

[MangroBongacello]

Is there a way to expand a form to show some additional controls after clicking a button? Something that would act like the Advanced button on Startup options window, would be great.

Thanx.

 

[Robbo1974]

Try adding a footer section to the form with the controls that you need and then attach the following to your buttons click event

Forms![MyForm].section(acFooter).visible = true

You would then reverse that with a command button in the footer section

HTH Robbo ;-)

 

[Robbo1974]

BTW, obviously you need the footer's visible property to be set to false when you load the form. Robbo ;-)

 

[MangroBongacello]

Robbo

Thanks for your reply, but this isn't solution for my problem. I already have something something on the footer which must be visible all the time. I guess I will have to programatically increase the footer and insert controls.

Thanks again
Mangro

 

[Robbo1974]

One last thought Mangro:

You could add a page header and footer to the form, move the controls that you currently have in the form footer to the page footer and then proceed as above. Robbo ;-)

 

[MangroBongacello]

Robbo

it seemed like a beautiful idea but unfotunatelly it looks like the page footer cannot be displayed in the form view. Any othe ideas?

 

[Robbo1974]

Unfortunately not Mangro, Bit of a pain that the page footer only prints and won't display on screen - didn't know that, never used them before.

Looks like you'll have to program it unless you're prepared to move the control that you currently have in the footer. Robbo ;-)