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.

  • dump

    The dump command, under a Unix system, is used to dump the entire file system to another device. By default, the dump output device is a tape device (/dev/tape). Now a day, however, it is often used with other devices such as another file system (from one hard drive to another.)

    Other systems use that same keyword. It is particularly the case of database systems. For instance, the PostgreSQL database has a pg_dump command.

    The opposite command is restore. That command is used to get the data from the output device and put it back on your hard drive.

  • group
  • hide
  • nested

    In computing, nested means an item defined inside another. It is most often used for loops, a loop can be declared inside another. The one inside is called the nested loop. In particular, two loops can be defined one after another or one inside the other. There is no other way to declare a loop.

  • RJ45