bmtech
asked on
Access 2007: Is there anyway to control Form positions by VBA?
Access 2007:
Is there anyway in which I can programatically control the position of a Form within Access? Currently the only method I can see is to drag the form in edit mode to your desired location and make sure you save it there. This has the obvious disadvantage that if you accidentally move a form whilst editing, but dont notice and then save it. You have to drag it back to correct your error.
What I would ideally like to do is specify a forms location either:
Degrees (0-360) and offset Realtive to the access screen centre... or
An Absolute screen location.
It strikes me as an obvious requirement. (ok maybe obvious only to me :))
Paul
Is there anyway in which I can programatically control the position of a Form within Access? Currently the only method I can see is to drag the form in edit mode to your desired location and make sure you save it there. This has the obvious disadvantage that if you accidentally move a form whilst editing, but dont notice and then save it. You have to drag it back to correct your error.
What I would ideally like to do is specify a forms location either:
Degrees (0-360) and offset Realtive to the access screen centre... or
An Absolute screen location.
It strikes me as an obvious requirement. (ok maybe obvious only to me :))
Paul
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok now all I need to do is work out a userfriendly method of creating an offset, shouldnt be too hard. All of my users use differing screen resolutions (very helpful). I already allow them to specify some default settings and store them in the registry using VBA,GETSETTING/SAVESETTING
Thanks,
Paul