Results 1 to 6 of 6
  1. #1
    c.d.power's Avatar
    c.d.power is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Location
    Florida
    Posts
    44

    How to Make Dialogue Boxes for Forms/Reports a Particular Size

    Good evening,

    The data entry forms in my DB are currently set to open as dialogue boxes. I am having trouble getting them to all be the same size, though. Some of them generate so big that they extend beyond the desktop area and others are too small. In a perfect world, I would like them to be cascade so that users could easily navigate between them if need be. If that's not possible, having them all the same size and simply overlapping each other when a new form/report is opened will suffice.

    Thank you in advance.

  2. #2
    John_G is offline VIP
    Windows 10 Access 2016
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    For the width, set the Width property of the whole form (all sections are the same width, and the height must be sufficient to display all the controls in all sections). For height, you set the Height property of each individual section (but the height must be sufficient to display all the controls in the section).

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,834
    If "set" means in design view, that may not be good enough as an opening form window can inherit certain attributes from other open forms, such as restored size that occurs after a minimize or maximize. Or if there is an open form that was maximized, a form opening afterwards can become maximized. You didn't say if the dialog forms were popups or not. Popups aren't usually affected by a previously maximized form.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,972
    What do you mean by 'dialog' boxes. Forms opened with acDialog parameter or with Popup and/or Modal properties set to Yes won't allow navigation between forms.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    c.d.power's Avatar
    c.d.power is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Location
    Florida
    Posts
    44
    Thanks for the replies.

    For more context, I have a "Home Page" form where users can navigate to various data entry forms. The command buttons are using OpenForm Macros with the Window Mode set to "Dialog". These forms are not Pop Ups.

    Hope this helps.

  6. #6
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,834
    the dialog option is a window parameter as you've noted, and does not apply to the form. Thus the form opens modal AND popup because the window mode overrides the form settings. You will not be able to access other forms until you dismiss such a form as a result.

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

Similar Threads

  1. Replies: 3
    Last Post: 07-13-2018, 12:14 PM
  2. Replies: 12
    Last Post: 07-07-2015, 03:14 PM
  3. Replies: 3
    Last Post: 10-27-2011, 11:39 AM
  4. is there a Size Limit to reports???
    By ghodges in forum Reports
    Replies: 5
    Last Post: 08-17-2010, 07:16 AM
  5. Replies: 0
    Last Post: 03-17-2009, 11:25 AM

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