Unanswered: Setting table Width and Height on Open
How do I set the position and size of a table when it is opened using a button.
I've used DoCmd.OpenTable OpenTable, acViewNormal, acAdd - to open the table but would prefer the position, height and Width to be set.
One way of doing this is to create 2 forms. On one form create it as a datasheet view of your table. On the other form, place the datasheet as a subform. You can then put a button on the main form which can adjust the width and height of the subform. You would use code such as: