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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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]
 
Back
Top