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]