Form Size

[Jeff]

Hi

The user for the Access database I created wants to change the size of
the screens which pop up after clicking a button tied to a macro. Is
there a way to specifically set the size of a screen? Also these
screens that pop up cannot be minimized or resized; the only button is
the X in the right corner. Can that be altered as well?

Thanks and happy holidays!

 

[John Vinson]

Hi

The user for the Access database I created wants to change the size of
the screens which pop up after clicking a button tied to a macro. Is
there a way to specifically set the size of a screen? Also these
screens that pop up cannot be minimized or resized; the only button is
the X in the right corner. Can that be altered as well?

Thanks and happy holidays!

What's popping up? Do you have a Query with prompt paramters like
[Enter start date:]?

If so, try opening a small unbound Form instead, and use a query
criterion such as

=[Forms]![NameOfTheForm]![NameOfTheControl]

If I'm misunderstanding the situation please explain and I'll try to
do the same...

John W. Vinson[MVP]

 

[Jeff]

The command button uses an OpenForm macro that opens this form. The new
opened form doesn't have the maximize or minimize buttons on the top
right hand corner. I was also interested in finding out more about
resizing the forms to fit on the screen.

Thanks.

 

[John Vinson]

The command button uses an OpenForm macro that opens this form. The new
opened form doesn't have the maximize or minimize buttons on the top
right hand corner. I was also interested in finding out more about
resizing the forms to fit on the screen.

You can put a line

DoCmd.Maximize

in the form's Open event to automatically maximize it.

John W. Vinson[MVP]