Syndicate content

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


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.


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.

Syndicate content


Terms of Site Index

Find the page/content you are looking for with our index.

  • download
  • float

    float is a type in most software languages referencing an IEEE floating point number. These numbers are generally defined on 32 or 64 bits with three parts: a sign, an exponent and a mantissa. There is also a bias which is not saved in the number. The sign is 0 (positive) or 1 (negative). This means you have a representation of: +0.0 and -0.0. The exponent is about 1/6th the total size in bits. The bias is added/subtracted from the exponent. In the end, it is a signed power of 2 exponent (i.e. exercises a shift on the mantissa.) The mantissa forms the current number.

  • highlightning
  • tool
  • www-data