asked on

Access2003 - Workable area based on screen resolution

Hi All,

I have an Access2003 database that changes the form / sub-form size based on the screen resolution. However, the problem is that I am using fixed values based on the screen size. I really want to be able to stretch the forms based on the usable area for each PC. By this I mean the actual usable height from the top of the screen to the Taskbar. If I can figure this out, I can program the size to fit - regardless of the situation. The width shouldn't really be an issue as most of my clients have the task bar at the bottom, but some have this locked, unlocked, or hidden when not in use.

Most of my clients are using Windows XP, but some are still running 2000.

Any suggestions would be really appreciated.

Scott McDaniel (EE MVE )

Do you mean you want your forms to fill the entire Access area? You can do this by issuing a DoCmd.Maximize in the form's Load or Open event.

Do you mean you want to resize your forms based on the screen resolution? Access forms expose a Resize event where you can do this, but it's a fairly huge task. You might be better off purchasing a 3rd party resizer and using that. Most 3rd part resizers provide font resizing, etc:

http://www.peterssoftware.com/ss.htm
http://www.jamiessoftware.tk/resizeform/rf_jump.html (this one's free)
http://www.fmsinc.com (includes one as part of their Total Access Compnents package)

Finally, the Developer's handbook provides code which you can use to build your own:
http://www.amazon.com/exec/obidos/I...8064361-7403703

Scott McDaniel (EE MVE )

Last link to Amazon is wrong:
http://www.amazon.com/Access-2002-Developers-Handbook-Set/dp/0782140114

ASKER CERTIFIED SOLUTION

stevbe

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Andy Brown

ASKER

That's perfect - I wish I'd seen that command before.