I haven't done any new developing in Access 2007 and I am wondering if there have been any advances in the form size to screen resolution issues in the new version. I normally create databases that are used in my office only; all the monitors are identical and are LCD so the users really only use one resolution (which makes things really easy). On the rare occasion I needed to build something for multiple resolutions I would use Jamie's form resizer. It doesn't look like there is a version for 2007 and I'm not able to purchase the commercial versions that do support 2007. I am now working on a application that will be used "company wide"; I really like for my forms to be centered and fill the screen when appropriate (regardless of resolution), I think it creates a more professional feel. Are there any new ways to accomplish this; if not what are most of you using to create a more polished look?
Form Size / Screen Resolution in Access 2007
- Thread starter jwleonard
- Start date
missinglinq
AWF VIP
- Local time
- Today, 01:22
- Joined
- Jun 20, 2003
- Messages
- 6,420
To my knowledge nothing along this line has been added. The most comprehensive review of 2007, Allen Briowne's The Good, the Bad and the Buggy, doesn't list anything like this in the "what's new" section. You have to remember, they just finally got around to dealing with the mousewheel!
If you're experienced using Jamie's Form Resizer, why not simply run up a dummy form with some controls in 2007 and see if it works? Just remember to develop in the lowest resolution you expect to deploy to; the documentation on this and all other resizers I've seen state that they work best in sizing up rather than sizing down.
The fact that Jamie's site doesn't make a statement about v2007 compatibility probably just means that he hasn't tested it under the new version. If you successfully use it with 2007 you might email them and let them know.
If you're experienced using Jamie's Form Resizer, why not simply run up a dummy form with some controls in 2007 and see if it works? Just remember to develop in the lowest resolution you expect to deploy to; the documentation on this and all other resizers I've seen state that they work best in sizing up rather than sizing down.
The fact that Jamie's site doesn't make a statement about v2007 compatibility probably just means that he hasn't tested it under the new version. If you successfully use it with 2007 you might email them and let them know.
I attempted to build a form and use the form resizer in 2007. It seemed to work at first but then I noticed a problem. I created the form at 1024x768 and updated form resizer appropriately; then loaded the form at 1200x800. There is a space on the right side and on the bottom that is about the size of a scroll bar (happens both with and without scroll bars). I tried to play with the constants in the code to adjust for the changes in 2007 to no avail. My concern is that the higher the resolution the bigger the space will be on the right and bottom (can't test right now as I am on the road so I only have my laptop). Also, it wasn't even close to working in tabbed mode, only overlapping windows. Does anyone know how to account for the changes that are causing this?
If not, how are most of you building your forms so they will look nice?
If not, how are most of you building your forms so they will look nice?
I am back home now and have confirmed the higher the resolution the more the form size is off. At 1650X1050 it only uses about 60% of the available space, I think one of the problems is the code doesn't account for the change in the ribbon size as the screen resolution changes.
- Local time
- Today, 06:22
- Joined
- Sep 12, 2006
- Messages
- 16,013
all the stuff ive seen is based on attaching/locking one/two sides of an object to a position relative to the form - so if you resize the form a comd button might move with the bottom/right border, and a text box might expand to fill available space
I don't use it those code bits, to be honest - but Access Cook Book (O'Reilly) has comprehensive routines/explanations to do this (I recommend this book very highly generally)
I don't use it those code bits, to be honest - but Access Cook Book (O'Reilly) has comprehensive routines/explanations to do this (I recommend this book very highly generally)
Ok but I'm little short with my english language knowledge so I only need VBA code for auto resizing forms depends on screen resolution.
Thanks
