Video modes

As you probably know, users' video displays vary widely. A video resolution of 1024 * 768 is most common, but many systems are set up with an 800 * 600 display. Higher resolution displays and even dual displays are becoming increasingly common. Just because you have a super-high-resolution monitor, you can't assume that everyone else does.

Video resolution can be a problem if your application relies on specific information being displayed on a single screen. For example, if you develop an input screen that uses 1280 * 1024 mode, users with a 1024 * 768 display will not be able to see the whole input screen without scrolling or zooming. Also, it's important to realize that a restored (that is, not maximized or minimized) workbook is displayed at its previous window size and position. In the extreme case, it's possible that a window saved by using a highresolution display may be completely off the screen when opened on a system running in a lower resolution.

Unfortunately, there's no way to automatically scale things so that they look the same regardless of the display resolution. In some cases, you can zoom the worksheet (using the Zoom control in the status bar), but doing so reliably may be difficult. Unless you're certain of the video resolution that the users of your application will use, you should probably design your application so it works with the lowest common denominator - 800 * 600 mode.

As you will learn later in the book (see Chapter 10), it's possible to determine the user's video resolution by using Windows API calls from VBA. In some cases, you may want to programmatically adjust things depending on the user's video resolution.



0 0

Post a comment