Form_MultiColumn.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 09 Jul 2008 at 4:13am |
This sample db demonstrates multi-column layout in forms. This could be
convenient in situations where only a small number of fields are involved. Adoption of multi-column layout (similar to across and then down layout in multi-column reports), where records are arranged across the screen, can facilitate optimum utilization of viewing area on continuous form or datasheet. Two alternative styles of multi-column display are covered (either style can be selected via an option group): Style 1 - Complete transposition: 1.1 - Field names appear at left, arranged in a vertical strip. Individual records appear across the screen as a series of vertical strips. For example, in a three column layout, there would be three data strips opposite the fieldname strip. 1.2 - If it were a blank form to start with, only the first data strip would be available as a new record (adjacent to field name strip). As soon as data entry in this strip is initiated, a fresh data strip (as a new record) becomes available at the right of current strip. 1.3 - When the last data strip at right is dirtied, a fresh strip of field names along with one blank data strip (representing new record) becomes available below the existing set of strips. Style 2 - Repetition of fields horizontally: 2.1 - The set of columns representing a conventional record gets repeated across the screen. For example, if three fields F1, F2 and F3 are involved and three column layout is desired, the column headers will be like F1 F2 F3 F1 F2 F3 F1 F2 F3 2.2 - To start with, one horizontal strip spanning first set of fields will be available as new record. As soon as data entry in this strip is initiated, a fresh data strip (as a new record) becomes available at the right of current strip, under the next set of fields. 2.3 - When the data strip under last set of field names is dirtied, a fresh blank data strip (representing new record) becomes available below the existing data strip under the first set of field names. For each style, both view are shown (continuous form as well as datasheet). Toggling between the two views takes place on clicking the pertinent command button. In datasheet view, there is certain wobble effect while conditional formatting is updated. No such problem is experienced in continuous form view Data strip representing new record is highlighted in light blue. Blank cells (if any) beyond this new data strip, are colored black, not available for use. Any attempt to enter such forbidden strip deflects the focus back to new record strip. Deletion of records can be carried out by double clicking on the pertinent data strip. Additional details are included in accompanying file Notes.txt Download Access 2000: uploads/37/Form_MultiColumn.zip |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |