How do I make a table open automatically to MAXIMIZE size?

G

Guest

I set the run to Maximize in the Properties/shortcut but it still opens in a
Normal size window the next time I open the table and I always have to
Maximize the window.
 
J

John Vinson

I set the run to Maximize in the Properties/shortcut but it still opens in a
Normal size window the next time I open the table and I always have to
Maximize the window.
Click to expand...

Table datasheets are of VERY limited value. This is one of many things
they cannot do.

Create a Datasheet or Continuous form based on your table; put a Macro
or VBA code in its Open event to maximize it. The VBA code would be
entered by clicking the ... icon by the open event, selecting Code
Builder, and entering

Private Sub Form_Open(Cancel as Integer)
DoCmd.Maximize
End Sub


John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working window in Access "sticks" to Maximum size 2
Maximize the form on the screen 6
Application Window Size 4
How to Opn The report window maximized 2
What happened to the minimize maximize buttons on objects? 2
Form Maximize? 1
Switchboard maximize at start up 4
Access2000 opens in half-size window 3

Top