Form Size Changing Randomly

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi, I've created several forms in Access 2007 and I've selected some to open
up as a pop-up and modal however they randomly open at differing sizes. I've
selected that they should auto re-size but som eopen as a full screen and
others as a cm square. Any ideas why this is happening?

Cheers Steve
 
Hi, I've created several forms in Access 2007 and I've selected some to open
up as a pop-up and modal however they randomly open at differing sizes. I've
selected that they should auto re-size but som eopen as a full screen and
others as a cm square. Any ideas why this is happening?

Cheers Steve
Click to expand...

Why don't you try the form's open event and specifying the exact size
for each form:

'Code the Form's Open event:
'DoCmd.MoveSize 1.5 * 1440, 3 * 1440, 2 * 1440, 1 * 1440
'The above will position the form 1 1/2 inches from the left edge of
'the window, 3 inches down from the top. The form will be sized 2
'inches by 1 inch in size.
'All measurements are in Twips, 1440 per inch.
'Look up the MoveSize method in VBA help.

the above should look ssimilar to the following..

Private Sub Form_Open(Cancel As Integer)
DoCmd.MoveSize 1.5 * 1440, 3 * 1440, 2 * 1440, 1 * 1440
End Sub
 
Back
Top