window resize issues after relink tables

[K90267000 via AccessMonster.com]

Hi All,
I hope i can explain my situation clearly..

I have resized the windows containing the forms to show a few rows of details
After resizing, i saved the forms and have no issues with the window sizes
whenever i open and close the forms after that. Everything is fine.

After I re-link the tables, I have issues keeping these window sizes
containing the forms:

If I had set the form properties AUTO RESIZE to "YES", this happens after i
relink:
-the 1st time i open the form, fine, all details are show (window sizes are
fine)
-i close the form
-the 2nd time i open the form, the window is resized in such a way, only one
row of details is shown

If I had set the form properties AUTO RESIZE to "NO", this happens after i
relink:
-the 1st time i open the form, fine, all details are show (window sizes are
fine)
-i close the form
-the 2nd time i open the form, the window is resized in such a way, the
window is very very small

The best solution I have now is and is doing is:
After relink, I open the forms for the 1st time (where the window sizes are
fine) and save all the forms.
Then the windows sizes will be fine after that.

Is there a better solution?
Can someone please enlighten me?
Thank you in advance
Ken

 

[Jeff Boyce]

Have you looked into using the

DoCmd.Maximize

command?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[K90267000 via AccessMonster.com]

Sorry I forgot to mention that the window is a "POP UP".
I tried your suggestion, Do.Cmd.Maximize on "On Load",
It did work, however, it turns the POP UP window into full screen.

What I looking at is to have it restore to its "resized" window size. My
issue is that on the 2nd opening of form after I re-linked, the original
window size is somehow being re-adjusted.

Thanks Jeff, you have set me on the correct path (ie, put a do.cmd in "on
load" or "on close")

Does anyone know, what is the "Do.Cmd" equivalent for the same action as :

When the pop up window of form is open, with "CONTROL BOX" set to "NO"
I right-click on the top left of the pop up window, and choose "SAVE"

Thanks!

Have you looked into using the

DoCmd.Maximize

command?

Hi All,
I hope i can explain my situation clearly..

[quoted text clipped - 31 lines]

Thank you in advance
Ken

 

[K90267000 via AccessMonster.com]

I forgot to mention : it is in "Continuous Forms" view
Thanks.

Sorry I forgot to mention that the window is a "POP UP".
I tried your suggestion, Do.Cmd.Maximize on "On Load",
It did work, however, it turns the POP UP window into full screen.

What I looking at is to have it restore to its "resized" window size. My
issue is that on the 2nd opening of form after I re-linked, the original
window size is somehow being re-adjusted.

Thanks Jeff, you have set me on the correct path (ie, put a do.cmd in "on
load" or "on close")

Does anyone know, what is the "Do.Cmd" equivalent for the same action as :

When the pop up window of form is open, with "CONTROL BOX" set to "NO"
I right-click on the top left of the pop up window, and choose "SAVE"

Thanks!

Have you looked into using the

[quoted text clipped - 7 lines]