CODEWITHSUNDEEP
vbams-accesspopupsizedatasheet
Shiela
Shiela

Reputation: 693

How to set the size of a pop-up subform datasheet to the desired window size below

Please bear with me as I am new to Access VBA.

I have here a subform with data sheet on it that I would like to display in Pop-Up View.

form1

If Pop Up is No, it displays the whole page.

img2

If Pop Up is Yes, it only displays this below:

halfimage

These are my properties:

properties

I tried to set Auto Resize to No, same thing happens.

What should I set here in the properties so at least it will automatically display this below:

Pop Up popup

Upvotes: 1

Views: 50

Answers (1)

Gustav
Gustav

Reputation: 55981

Set the form's property AutoCentering to Yes.

Use this code in the OnLoad event to set the width and the height of the form, for example:

Private Sub Form_Load()

    DoCmd.MoveSize , , 12000, 8000

End Sub

Of course, you can also set the Top and Left position, but those are relative to the screen.

Upvotes: 1

Related Questions