window resize issues after relink tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

K90267000 - 28 May 2007 03:24 GMT

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

Reply to this Message

Jeff Boyce - 28 May 2007 14:07 GMT

Have you looked into using the

DoCmd.Maximize

command?

Signature

Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

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

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

> Hi All,
> I hope i can explain my situation clearly..
[quoted text clipped - 31 lines]
> Thank you in advance :)
> Ken

Reply to this Message

K90267000 - 29 May 2007 02:43 GMT

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]
>> Thank you in advance :)
>> Ken

Reply to this Message

K90267000 - 29 May 2007 04:52 GMT

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",
[quoted text clipped - 19 lines]
>>> Thank you in advance :)
>>> Ken

Reply to this Message