Set form size and location in Access 2010

[latex88]

I want to make my form a certain size and be displayed at certain location of the monitor when open with Access Runtime. I don't see it, but is there a form setting I can modify, or this has to done with macro or VBA with an event procedure on open?

This was so easily done in Access 2003, but I have a heck of time finding a solution for 2010, which I really hate, by the way.

 

[boblarson]

Perhaps this will help:

http://www.btabdevelopment.com/ts/2010tabbed

 

[latex88]

Perhaps this will help:

http://www.btabdevelopment.com/ts/2010tabbed

When implementing your suggestion, it seems to work fine in MS Access itself when viewing between design and form view. However, when I exit and launch the application again, the forms do not save in their dimensions or location.

I cannot get MS Runtime to work either.

 

[boblarson]

Once you change from tabbed view to overlapping window view you need to size the windows the way you want and then put it into form view and then go to FILE > SAVE to save it.

If you want to experiment you can use the DoCmd.MoveSize command or you can set the form's dimensions using something like this in the form's On Open event.

Me.InsideWidth = 3 * 1440 ' (3 is inches and 1440 is the number of TWIPS in an inch)
Me.InsideHeight = 4.5 * 1440

 

[latex88]

Once you change from tabbed view to overlapping window view you need to size the windows the way you want and then put it into form view and then go to FILE > SAVE to save it.

If you want to experiment you can use the DoCmd.MoveSize command or you can set the form's dimensions using something like this in the form's On Open event.

Me.InsideWidth = 3 * 1440 ' (3 is inches and 1440 is the number of TWIPS in an inch)
Me.InsideHeight = 4.5 * 1440

Bob,

Have you used Runtime? I am creating the application for other folks to use with Runtime. I want the form to be shown about short of half on the right hand side of the monitor. The users will be using another application concurrently on the left side of the monitor. I cannot get Runtime to open it up at the size and location I want.

 

[boblarson]

Post the code for which you currently have and describe what it actually does so I might be able to suggest a fix.

 

[latex88]

Below is what I had, which I commented out.


DoCmd.MoveSize 10500, 0, 11800, 13000

 

[Zeusmelat]

Hello all.

I tried, in the "on load" form event with:
Me.InsideWidth = 20000
Me.InsideHeight = 10000
and it is working for the FORM size.

But What I would also like, is to get the form fully overlapped with the Access window.
(Users will then not see any access to anything behind: forms, code,...)

How to set the Access window fixed to a certain value from VBA code?
How to overlap that window with the form?

(I tried setting the overlapping window option comented above but did not see any changes for this issue)

...
Perhaps, this could also help with another problem: projector autosizing.


Thanks! (My first post!)