Size of the access window

[Guest]

Hi all,
I have a question about sizing the access window itself from vb-code.
I have a form that automatically comes up at start up.
Its properties are
Scroll bars: neither
Auto resize: Yes
Auto Center:Yes
Border style:none
Control box: none
Width: 22,296cm (is there no Height property?)
Pop up:no
Modal:yes
With these settings the form fills the 'upper' access window without any
subwindow or scrollbars etc. That is what i want, but when i start the
application it comes up at the size the user last left access. So it can be
big or small.
Question 1: I would like to determine the size of the accesswindow with
these property settings and in the on-open event of the form i want to resize
the accesswindow itself.
Question 2: how to prevent the user from resizing the access main window?

Can anyone help me?

 

[StevenR via AccessMonster.com]

Hi all,
I have a question about sizing the access window itself from vb-code.
I have a form that automatically comes up at start up.
Its properties are
Scroll bars: neither
Auto resize: Yes
Auto Center:Yes
Border style:none
Control box: none
Width: 22,296cm (is there no Height property?)
Pop up:no
Modal:yes
With these settings the form fills the 'upper' access window without any
subwindow or scrollbars etc. That is what i want, but when i start the
application it comes up at the size the user last left access. So it can be
big or small.
Question 1: I would like to determine the size of the accesswindow with
these property settings and in the on-open event of the form i want to resize
the accesswindow itself.
Question 2: how to prevent the user from resizing the access main window?

Can anyone help me?

The only way I know is to set the screen to max size on the Open event with
this code:

DoCmd.Maximize

this doesnt stop the user from resizing it but it will make it open in max
view evertime you open the form.

 

[Guest]

Thanks for yourreply, but maximizing is not what i am looking for..