The client database I am working on has a form that, based on the age of the client, shows an aging infor subform on it. It is located to the right of all the other data and in a big blank space. However, all the primary data is on the left of the form and the aging information only applies to a small portion and this form is not visible if the client is not int his category. But it makes for a big empty space on the right. I am trying to figure out how, in VBA, to make the form smaller unless the client is in the aging category and then show the full form with this subform. But when I try to make the form small in code, it still opens full size. Can this even be done if this form is on the right side and even with code I cannot make the main form thinner?