Results 1 to 3 of 3
  1. #1
    Middlemarch is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2015
    Posts
    340

    Battling Access Forms

    I've never quite mastered what makes Access Forms tick. (Compared to nice sensible Excel ones!)
    I have one which is really irritating.. it opens with this line

    Code:
    DoCmd.OpenForm "frmMove", acWindowNormal, , , , acDialog, RetVal1
    Most of the time it's OK. But sometimes while developing & testing some code, it can open full screen rather than as a small window on top of other stuff (which is what's wanted).
    Both Popup and Modal properties are set No. (Although acDialog means modal, yes ?)

    Is there anything I can do to make the Form to always Open as I want it, no matter what ?

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    acDialog means popup and modal so should open on top, but there is nowhere you are setting the form size so it will use the size of the form you have - which may be full screen. Ensure when editing you have set the form size correctly or use some code to set the form in the open event (use the move command)

  3. #3
    Middlemarch is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2015
    Posts
    340
    OK, thanks. Will try the Move command. It opens on top of another form (which is full screen) and is most often correct (size) but inexplicably full screen now and again.

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

Similar Threads

  1. Replies: 2
    Last Post: 04-05-2016, 08:29 AM
  2. Replies: 3
    Last Post: 10-23-2013, 08:11 AM
  3. Replies: 2
    Last Post: 11-21-2012, 09:57 AM
  4. Battling to create a pricelist form
    By funi.t in forum Forms
    Replies: 4
    Last Post: 01-12-2012, 12:08 AM
  5. Replies: 2
    Last Post: 12-08-2011, 12:03 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