Solved

How make form fill the screen

Posted on 2013-11-21
2
322 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

867 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now