Force forms to specific screen - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Force forms to specific screen

Dan Jackson

3 years ago

Hi Guys,

Real quick one, i'm sure its come up before.

We have 2 Large monitors on the wall in the office. I'm currently using one to hold a "Salesboard" and this is achieved by opening access and opening the form full screen. I have [LEFT] and [RIGHT] Buttons on my main menu to open the forms

I now want to open my 2nd report on the second screen which is done every morning.

Is there a "Move" command i can use to force the Left form to the left monitor and the Right Form to the right monitor? Its done via remote so switching screens is ok but a pain.

Many Thanks

	Juan C Rivera @Reply 3 years ago
Private Sub Form_Load() DoCmd.MoveSize 0, 0 End Sub this will move it to monitor number 1 and adjust the 0,0 to move to your second monitor. the numbers will be different due to screen resolution.

	Dan Jackson OP @Reply 3 years ago
Awesome, that's what i was looking for but wanted to be sure. Cheers Juan

	Dan Jackson OP @Reply 3 years ago
I just tried this by opening Access on the left screen (Res 1024x768) and opening the right screen form with the following code but didn't work - stayed on the left screen Private Sub Form_Load() DoCmd.MoveSize 1025, 0 End Sub

	Juan C Rivera @Reply 3 years ago
Oh WOW when you find the answer let me know I was way off...

	Dan Jackson OP @Reply 3 years ago
I think you were along the right path BUT i think it only covers the access canvas. So, if the access window is 1024x768, then the max move space is 1024x768. I was thinking i could create two access files but would still have the same problem that access would remember where the LAST ACCESS window was open

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View