Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Aug 2003
    Location
    amsterdam, Netherlands
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    lock form size (access 2000)

    hi all,

    I can recall reading something about this before but I can't find the post anymore. maybe someone knows?

    the thing is this
    I have a couple forms and what I want is to open some forms maximized and
    some in normal format. what happens now is that if I open the first form and
    normalize it all the other forms open in normalized format too. or when I
    maxime a form all the other forms that are opend next are maximized too.
    how can I change this?
    how can I set for every form apart in what way it should open
    It is probably a simple thing in the form properties but I've tried all I
    could find and nothing seems to make a difference.

    Thanks ahead.

    Diederik

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: lock form size (access 2000)

    A form with Popup = Yes (in the Other tab of the Properties window), or opened using DoCmd.OpenForm with the WindowMode argument set to acDialog, is always opened "restored" regardless of the state of other forms. that way, you can open a "restored" form on top of a maximized form. But otherwise, maximizing one window within Access will maximize all others too, and ditto for restoring one window. That is the way the multi-document interface (MDI) works.

    Added: you could resize forms in code to fill the Access window without being maximized, using DoCmd.MoveSize.

  3. #3
    Lounger
    Join Date
    Aug 2003
    Location
    amsterdam, Netherlands
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: lock form size (access 2000)

    Hi Hans,

    the popup option could be a good solution.
    But then one more question is how do I get access to close the form at lostfocus?
    couse I have a couple forms that open in "normal" format

    (this is actually what I couldn't find in the first place so thats why I went searching for fixing the form size)

    Tnx,

    Diederik

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: lock form size (access 2000)

    If you also set Modal = Yes (or use DoCmd.OpenForm with acDialog) the user cannot activate other windows in the database; (s)he must close the modal window before activating another window.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •