Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2002
    Posts
    173

    Unanswered: keeping forms maximized

    I have sub forms for prompts coming off of main forms. The main form is set to maximize when it opens. Whenever the prompt comes up the main forms shrinks down. Is there a way to keep it maximized at all times so the user doesn't see it resize?

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    VBA to maximise form

    Add this code to the form open event

    Private Sub Form_Open(Cancel As Integer)

    DoCmd.maximise

    End Sub
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Jan 2003
    Location
    Aberdeen, Scotland, UK
    Posts
    168
    even with maximization the form will shrink down when another is opened. Don't know why. But....

    Make the form that opens on top a Pop-up.

  4. #4
    Join Date
    Aug 2003
    Posts
    1
    Originally posted by johncameron
    even with maximization the form will shrink down when another is opened. Don't know why. But....

    Make the form that opens on top a Pop-up.
    I am having this same problem and was curious if anyone has a solution that will work.

    Thank you.

  5. #5
    Join Date
    Dec 2002
    Location
    Glasgow, UK
    Posts
    100
    If you don't need to use menus you could set the properties of your main form to: Pop Up = Yes & Modal = Yes - these properties are in the "other" tab of the form properties. Just make sure you have a docmd.maximize statement on the form open event.
    Access XP & WinXP Pro

  6. #6
    Join Date
    Aug 2003
    Location
    Bunker
    Posts
    4
    I got the same problem....

    WIll try it later tho...

    Just wondering..do both work?

    DoCmd.maximise

    DoCmd.maximize

  7. #7
    Join Date
    Dec 2002
    Location
    Glasgow, UK
    Posts
    100
    I also should mention that you need to make all the forms have pop up = true & modal = true or they will not be visible over the main form when you open them.

    as to the maximize/maximise issue mine is definately maximiZe - I always assumed that this was because VB is an american english design
    Access XP & WinXP Pro

Posting Permissions

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