How to have a correct size in a form?

[hanski]

Hi.

I have a form which will open when I press a button in a other form.
But when that form will open, it has various sum of data. That's why
the form is not automatically in right size. Sometimes it is too large
and sometimes to small. Is it possibe to make it open so that it will
always be in a right size?


Hannu

 

[John W. Vinson]

Hi.

I have a form which will open when I press a button in a other form.
But when that form will open, it has various sum of data. That's why
the form is not automatically in right size. Sometimes it is too large
and sometimes to small. Is it possibe to make it open so that it will
always be in a right size?


Hannu

Do you want the form to automatically change its width? its height? or both?
dependent on data? That's going to be really difficult; it's not how Access
forms typically work!

You would essentially need to open the form hidden; count the number of
records; go into design mode; change the size of the form; save it with the
new size; and finally go back into data mode and make it visible. This will be
*slow* and will bloat your database since it must keep deleting the old form
and saving the new one.

Can you instead simply open the form big enough to show the typical data, and
let users use the scrollbar if there is more data than will fit?

John W. Vinson [MVP]

 

[hanski]

Do you want the form to automatically change its width? its height? or both?
dependent on data? That's going to be really difficult; it's not how Access
forms typically work!

You would essentially need to open the form hidden; count the number of
records; go into design mode; change the size of the form; save it with the
new size; and finally go back into data mode and make it visible. This will be
*slow* and will bloat your database since it must keep deleting the old form
and saving the new one.

Can you instead simply open the form big enough to show the typical data,and
let users use the scrollbar if there is more data than will fit?

John W. Vinson [MVP]

ok, I will open the form big enough.

thanks