Align Form Right?

[pswilliams0]

Hi all,
I'm developing a complex database of forms and queries that things that I want to display at the same time. Unfortunately, the screen size and resolution that the access database is displayed on changes.

I am familiar with the DoCmd.Movesize argument - but is there a way to align a form to the right side of the visible screen instead of basing everything off of the top left corner? Thanks in advance!

 

[spikepl]

I guess you can do the arithmetic yoursef and still use MoveSize
http://www.exceltip.com/st/Determine_the_screen_size_using_VBA_in_Microsoft_Excel/434.html

although in a left-to-right based culture I am not too sure what the point of that would be.

 

[Pat Hartman]

There are at least two products sold that will solve this problem for you in Access. Peter's Software (www.peterssoftware.com) has a shrinker-stretcher you can add to your application that will resize forms to fit various monitor resolutions and so does FMS (WWW.FMSINC.com)

 

[pswilliams0]

I suppose I could be a bit more clear. I have a taskbar with buttons to operate the various forms. I am trying to find a way to have that taskbar show up in the bottom right corner of the screen, regardless of the resolution. Can this be done in VBA?

Thanks

 

[Pat Hartman]

Yes. You need to "find" the bottom right corner of the screen with the code spikepl referred to (I didn't check it) and then calculate how many pixels to move the control.
The products I refered to will do this for you automatically. You design for the lowest normal resolution and the resizing code will enlarge the controls for those with larger monitors. Peter's solution explicitly handles resolution. The FMS solution (which I have not used), just seems to shrink and grow the controls if you resize the form.

Having a fixed element at the bottom right of a form is always problematic because that is the area that disappears when the form can't fit. You might consider moving the taskbar up and to the left where it will always be visible.