Resizing forms based on data

[dmr]

I have a form with a subform (see red arrow). I'd like the subform to resize automatically to fit the records it contains (and the form to resize to accomodate). Also, I want the form to be invisible (and take up no space) if there are no records.

I can't figure out how to do this. I've set the "can grow" and "can shrink" properties to yes on the subform and form, and it doesn't seem to help. Any ideas?

 

[HiTechCoach]

I have a form with a subform (see red arrow). I'd like the subform to resize automatically to fit the records it contains (and the form to resize to accomodate). Also, I want the form to be invisible (and take up no space) if there are no records.

I can't figure out how to do this. I've set the "can grow" and "can shrink" properties to yes on the subform and form, and it doesn't seem to help. Any ideas?

The can Grow and Can Shrink properties are used only if the form is actually printed to the printer, not when displaying on the monitor.

It is probably possible to do what you want. I have never tied it. AFAIK, you will have to write VBA code to handle this.

I am really curious. I am always trying to improve the GUI for humans.

Why you would want to do this?
What GUI benefit will be gained?