Auto resize tables in Access

[electrix]

Hi. I have a main form that has three command buttons, each of which opens a table. Is there a way to set the default size of the window that opens when I click on one of these buttons? In other words, is there a way that I can do this and still efficiently utilize my window space in order to see both most of the form and the table that pops up?

 

[boblarson]

You can't do anything really with tables. And, in fact users should not be allowed into the tables directly. Create a form BASED on the table (or query of the table) and you can set it to be Datasheet view which will make it LOOK like the table is opened. Then you can use its Open event to set the size of the window (using Me.InsideHeight and Me.InsideWidth).

 

[electrix]

Okay. I've created buttons to open the forms I just made. When I access them from the list of forms they open into datasheet view. However, when I click the buttons, they open into form view. How can I set it so that clicking the buttons will open the forms up into datasheet view?

 

[boblarson]

Okay. I've created buttons to open the forms I just made. When I access them from the list of forms they open into datasheet view. However, when I click the buttons, they open into form view. How can I set it so that clicking the buttons will open the forms up into datasheet view?

DoCmd.OpenForm "FormNameHere", acFormDS