The Linux Page

MS-Access sub-form auto-resize instead of staying put

Problem

Today I ran in a problem where I created a new form and the sub-form inside that form would auto-resize itself. Strangely enough, all my other forms also have a sub-form and that sub-form is not auto-resized... so what gives?!

I did not find anything about preventing an auto-resize of a sub-form. Found many pages on the net about how to write code to resize a form "manually". But that really did not help.

Solution

As I created that new form, I marked it as "Auto Resize" to No. This seems logical if you do not want a form to get resized. Think again! The form itself would get resized and the sub-form is somehow resized to some random size.

That was it. I tried all sorts of flags and resized this and that, nothing mattered except that one flag.

Once I had "Auto Resize" back to Yes, my form was fixed.