Results 1 to 6 of 6
  1. #1
    Ally1205 is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Jul 2013
    Posts
    68

    Access2000 - how do I configure a form so that it always opens fully-maximised?

    Hello,
    How do I configure a form so that it always opens fully-maximised?



    Thank you...

  2. #2
    BluffMeAllIn is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Dec 2013
    Location
    Canada
    Posts
    21
    Hi Ally,

    The Auto Resize and Fit to Screen form properties both set to Yes should accomplish this.

    Dave

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I use a little code in the form open event

    Code:
    Private Sub Form_Open(Cancel As Integer)
       DoCmd.Maximize
    End Sub

    Once the form is maximized, all objects opened will be maximized.
    So I use the following code when the form closes:
    Code:
    Private Sub Form_Close()
       DoCmd.Restore
    End Sub

  4. #4
    Ally1205 is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Jul 2013
    Posts
    68
    Hi Steve! That works a treat. Thank you so much!

  5. #5
    Ally1205 is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Jul 2013
    Posts
    68
    Dave,
    Many thanks for this suggestion. I can see 'Auto Resize' but not 'fit to screen' anywhere in my form's properties. (Wrong version, perhaps?) Anyway, Steve's coding solution solved it...

    Ally

  6. #6
    BluffMeAllIn is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Dec 2013
    Location
    Canada
    Posts
    21
    Yeah very possible the fit to screen is not in your version or something, I had popped back to the thread yesterday after seeing someone else had responded and figured if you were able to code it that Steve's response would also work. I had initially looked at it from a non-coding aspect as seems at least many of the threads I have viewed since I joined are not the savyist on the coding side.

    Just glad you got your issue resolved.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 07-16-2012, 02:10 PM
  2. How to configure odbc-connection from vba-code
    By torunsu in forum Import/Export Data
    Replies: 3
    Last Post: 09-06-2011, 07:27 AM
  3. Pop Up Reports Maximised Issue
    By GraemeG in forum Reports
    Replies: 7
    Last Post: 07-27-2011, 07:55 AM
  4. Access won't stay maximised
    By eckles in forum Access
    Replies: 7
    Last Post: 06-21-2011, 01:55 AM
  5. Expression changes between Access2000 and 2003
    By INeedHelp in forum Programming
    Replies: 0
    Last Post: 03-17-2011, 08:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums