Solved

How make form fill the screen

Posted on 2013-11-21
2
323 Views
Last Modified: 2013-11-21
I have a database setup as overlapping windows but I have one form set from a command button on a form to open in datasheet view.  But I want it to fill the screen when it opens.  It is not doing this.  Here is my code for the onclick event of the command button:

DoCmd.OpenForm "frmMemberGoals", acFormDS, , , acFormEdit, acWindowNormal

How can I make the form fill the screen?
0
Comment
Question by:SteveL13
2 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 39667337
Try adding this to the open event of your datasheet:

Docmd.Maximize

and this to it's close event:

Docmd.Restore
0
 

Author Comment

by:SteveL13
ID: 39667348
Yep.  Thanks.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question