Syndicate content

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.

Syndicate content

     

Terms of Site Index

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

  • combo
  • CurrentDb
  • device

    In Information Technology a device is generally a physical item that can be controlled by the computer. The hard drive, a USB camera, a memory chip, etc. are all devices.

  • strong
  • XML

    Extensible markup language. First mainly used on the Internet, XML was born out of a constrained version of HTML (SGML). It is now used for all sorts of data.