Split form size

[Jeffrey Cox]

Hi All,

I have a split form with the data sheet on the left (a list of student names
to select record in main form). The split form finds record details from one
table only.

The problem is that I can't resize the whole form, it's too wide. I've tried
altering the size in the properties Width and Size of Split form, but every
time I save it and open it again, it's back at that original size!!! There
are no controls near the border, so that's not the problem.

Any ideas really welcome.

 

[June7]

I have the opposite situation. Data below the main. Form opens too narrow.
Maybe MS got wires crossed!
Been wanting this feature ever since I started with Access but can't use it
in this state.

 

[June7]

Found a solution from another post on this site.
http://www.microsoft.com/communitie...98d2&mid=5b0b065c-8f70-4ca3-bc02-725e40956069

Here is excerpt:
"I did find a workaround: resizing the form window to the desired width in
the form's Load event. It took only one line of code:

DoCmd.MoveSize , , 11400

The number 11400 was determined empirically, by manually sizing the form and
then inspecting its WindowWidth property."

 

[June7]

I celebrated too soon. The form opens to proper size but vertical scroll bar
won't show even though property is set for it. Guess better start new thread
on that!

 

[June7]

Got scroll bar back after resizing the SplitFormSize property a bit larger.

 

[June7]

Experimenting, removed the On Load event and changed AutoResize to yes along
with AutoCenter yes and FitToScreen no. Now opens just fine.

 

[June7]

My latest and hope last word:
When the split form opens by call from another form or manually by me from
the project navigator in form view, it's fine. Switching from design view
then to form view, it is sized too narrow.