I have followed the suggested code to resize a form Access 2010 VBA Forms - Automatic Form Resize.
I have a few issues with this code:
When Access opens, the form is automatically opened but it is not recognizing this code. If I open the form in Designer and then go back to the form, it has the code applied. What step would the EventProcedure need to be applied to? Form_Open?
The subform is not resizing - there is a subform within the original form. I have added the code to the primary form and the subform is not affected. If I add the code to the subform, also, then the font on the subform is HUGE. Could it be using the acHeader and acFooter from the main form? And is there anything that I should be considering for the subform so that it recognizes its own window size?
When the form initially opens without the code activated, the subform is overlapping the tabs of the main form. The subform is the content that is supposed to display on the tabs, so I do not understand why it would overlap the tab.
Since I am very new to working in VBA, any assistance is greatly appreciated. We have multiple forms and subforms within an existing application and I am tasked with either resizing everything manually to larger font, or finding a solution that will allow the user to resize the page/font themselves - which is the reference I have above. (questions/13337942)
Code was applied but is not executing when form opens with the main application - only after opening in Designer.
Subform is not being affected. When adding the same code to the subform, the font in the subform is a few times larger than the font in the main form.
When code is not activated (upon initial open with application), the subform is overlapping the tabs of the main form - and the subform resides within the tab.
