split view popup form has resize problems

P

Preston

Hi,
I am trying to get a split form to popup with the same dimensions every
time and not change itself. I can't seem to get this to happen. I have played
with autoresize, resize, autocenter, borderstyle and the form just seems to
size itself however it sees fit. i change the size of the form manually and
then save it and it still does the same thing. how can i make the form keep
its size?
thank you
 
P

Preston

update:
i tried using the code in a previous post:
+++++++++++++++++++++++++++++
Private Sub Form_Open(Cancel As Integer)

Me.Detail.Height = 1440 * 3
Me.Width = 1440 * 3
DoCmd.SelectObject acForm, Me.Name
DoCmd.RunCommand acCmdSizeToFitForm

End Sub

The unit of measurement is "twips", and there are 1440 twips to an inch, so
the above example produces a form which is about 3 inches square
++++++++++++++++++++++++++++++++++++

but this comes back with an error that accmdsizetofitform isn't available.
it does the same thing whether i run it in onload or onopen. still haven't
been able to figure out why they're resizing themselves weirdly. btw i have 4
forms in my db that are popups and 2 are split view (datasheet on the bottom)
with just the from header for looks on the top. These two forms are the ones
that do the odd resizing trick. The two that are regular forms with subforms
in them don't do this.
Thank you again.
 
P

Preston

i was able to make it work with a suggestion of using in the form_open() event
docmd.movesize right,left,width,height
this works. for some reason i couldn't use docmd.runcommand acsizetofitform.
it would error on me.
anyway
anyone know why the forms would have sizing problems on opening in the first
place? i'm curious to know.
thank you,
Preston
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form keeps opening up too large 2
Control Form Size in 2007 2
Split form size 6
MoveSize for form AND report 4
Positioning a Form 2
Resize popup form 8
Form Width Grows 6
Split Form Size 1

Top