Access 2007 is resizing my forms!

  • Thread starter Thread starter UsenetUser
  • Start date Start date
U

UsenetUser

Access 2007 SP1

I create several split forms, size them to around 5" wide in design
view, save in design view, turn off (or leave on it doesn't matter)
autoresize, autocenter, fit to screen. Close the form, open it again.
The form will open anywhere from 7 to 20" wide, depending which form,
and there is no obvious reason one will be 7" and other 20".

Same thing happens with datasheets except the size on those seems to
'stick' for a while - hard to say exactly how long but at least until
the datasheet is immediately reopened. Not so with the split forms.

I've come across a couple of other posts about this problem but no
solutions. It is very frustrating and the client is not happy about
it.

Help would be appreciated!
 
I had this exact same problem (someone kindly posted a reply but can't find
the post to say thanks).

You basically need to specify the form size when opening, so copy this code
into your Form Load

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

Thank you very much for that. There is nothing in the KB about it - I
wonder when MS is going to acknowledge the problem.

Have a great day!
 
Back
Top