Link to home
Start Free TrialLog in
Avatar of Zoran Trifunovic
Zoran Trifunovic

asked on

Navigation form autoresize

Hi everyone!
I am having trouble to auto resize my navigation form in MS Access.
I've used the code from Access Developers Handbook and it works perfectly when I apply it to a single form. However, when I try to resize the same form in my navigation form the code is not working.
I get the feeling the Access Developers Handbook code is working but not on navigation subform. It only needs a minor adjustment and I can't really get into the code that deep to understand what's happening. I'm sure that someone with a bit more knowledge than me would know how to do it. The code is in attach.
I would really appreciate if you could help me on this as I'm beginning to be very frustrated.

Thanks in advance!
Avatar of Fabrice Lambert
Fabrice Lambert
Flag of France image

Hi,

Afraid you forgot the attachment :p

If I understood right, you have a form holding a subform right ?
Well, the subform isn't directly held by the main form, there is a control in between them.
The main form hold a control (type Access.SubForm) holding the subform.
That's the control you'll need to resize.
Avatar of Zoran Trifunovic
Zoran Trifunovic

ASKER

Hi Fabrice,

sorry for the attach, here it is. Yes exactly , the form that I want to resize resides on the navigation subform and I am trying to figure out the way how to modify the code to make it work. When the form first loads it works and the form on navigation subform is resized. As soon as I navigate to another form the code stops working
If you have any ideas, please share.

Thanks again!
Resolution.zip
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.