Form Size Differs when opened ?

[saleemMSMS]

Hi

I'm using Access 2007 and this is the problem i encountered.
when i design a form in the design view i give dimension, then i check them in the layout view and it seems OK.
but when i open it as a dialog box, the for gets shrink and 2 scroll bars appear ether side.
how can i open the form with the same size ?

btw, i'm not using the overlapping windows method in access 2007 (i mean i changed the default way of displaying forms in access 2007 and now the forms are displaying like in Access 2003)

 

[FREDDY67]

Hi

You can use DoCmd.MoveSize, here is a link to explain http://msdn.microsoft.com/en-us/library/bb238004.aspx

As it explains the measurements are in twips & in your design view your form will probably be in centimetres, if you multiply your size in cm by 566.929133858279 it will give a fairly accurate conversion to twips.

Freddy

 

[xolo]

I had exactly the same problem before. What I did to solve it is to use this:

Private Sub Form_Open(Cancel As Integer)
InsideHeight = [some number]
InsideWidth = [some number]
End Sub

I hope it helps.