Access 2007 split form window size (BUG???)

[Mark Andrews]

I created a sample Access 2007 database with one table and two forms and one
line of code.

frmMain has one button and one line of code:
DoCmd.OpenForm "frmNext",,,,,acDialog

frmNext is a form set to "Split Form" as the default (no code), throw
whatever fields you want on the form

It seemed to work fine until I switched the database options to Overlapping
windows and then frmNext freaks out and shows up HUGE.

Please help I would like to use split form view.

I have ms access: 12.0.6304.5000 (I think that's SP1)

Is this a bug that can be reported or solved?????

Thanks in advance,
Mark

 

[Mark Andrews]

I went with:
'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.

As a short term solution. I was hoping I didn't have to do this becuase I
could have a few forms and
I would rather not code the size of every window.

If anyone knows the real fix to this problem please let me know.
Mark

 

[Albert D. Kallal]

I went with:

'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.

As a short term solution. I was hoping I didn't have to do this becuase I
could have a few forms and
I would rather not code the size of every window.

If anyone knows the real fix to this problem please let me know.
Mark

This looks rather broken to me also.......

The same problem occurs with sp2...

I going to write this up as a bug. I suppose it is possbile that split forms
are supposed work this way by design, but that seems rather wrong if that is
the case....

Your workaround is about the best solution I seen so far (thanks for sharing
your workaround by the way).

I going to submit this as a bug.....

I think the split forms are REALLY nice new feature of ms-access. However, I
don't see a lot of people using them right now, hence your question/issue
has not come up that much. However, if we can't set the size of the split
form, then I think this really holds back the adoption rate of this new
feature. Maybe few are using these forms because we can't size them
correctly????

I am 100% on you with this one....these forms don't size work correctly...

 

[Mark Andrews]

Albert,

Thanks for submitting the bug! I like Access2007 and have found a good
general design for apps and use split forms a good deal but it's kinda
annoying all the bugs that still exist. I guess I should move to SP2.

Mark
RPT Software
http://www.rptsoftware.com