Scroll (Worksheet)

The Scroll radio button appears on the Worksheet header only when the screen resolution is 640x480.

We recommend the following steps when using Access ELF in low resolution screen modes. First, make sure that as much screen "real-estate" as possible is available by configuring Windows and Access accordingly. You should set the AutoHide property of the Windows Taskbar to On. (Right-click the Taskbar, click Properties, and check AutoHide.) Next, undock the Access ELF Toolbar from the right edge of the screen, so that it floats (see Access ELF Toolbar). Conserve even more space by hiding the Microsoft Access Form Toolbar whenever our Worksheet is displayed. (With an open Worksheet, click View/Toolbars and uncheck Form View.) Close and reopen the Worksheet, and maximize the Worksheet by clicking the Maximize icon in the upper right. The entire Worksheet should fit (just barely) using this technique.

The Scroll radio button is provided as a last-chance effort to squeeze the Worksheet onto a low resolution monitor. In case your screen does not match our test machines (and part of your Worksheet remains off-screen), click the Scroll radio button to enable Worksheet scrolling. The button has three states: Inactive, or greyed (no scrolling), On (both horizontal and vertical scrolling) and Off (horizontal scrolling only).

Note that in low resolution mode, some of the controls are placed differently than in high res (and as the documentation shows). For example, the export to Excel function is triggered, not by a button in the Worksheet footer, but via the Excel icon to the right of the slider. Similarly, Hierarchy (tree) displays are triggered not by the "Organizational Chart" link which appears upper-right at high resolution, but via the Hierarchy icon next to Excel's.

To force the Worksheet to resize itself to the currently available screen space, double-click any blank area of the footer (for example, the margin between the SQL and Explanation panels).

The blue header and footer arrows. which appear to the right of the Worksheet in higher resolutions, do not appear in 640x480. This means that to display a Worksheet full-screen (without header or footer) you'll need to call on a few "tricks". The first trick is that the header can be toggled on/off by double-clicking any blank area of the grid, from the middle of the screen up. The footer can be toggled by double-clicking any blank area of the grid, from the middle down. This lets you display a grid full-screen (you can scroll any grid all the way to the right to reach a blank region, then scroll back after hiding screen areas). However, this still leaves the problem of how to display a graph in full-screen mode. For this you need to use a second hidden feature of the Worksheet, the ability to jump from one display mode to the next using the <Ctrl+Tab> key combination. Put these two techniques into action together to get complete control of the Worksheet even on low resolution displays.