Print Page | Close Window

Form_MultiColumn.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=102
Printed Date: 20 Oct 2017 at 11:50am


Topic: Form_MultiColumn.mdb
Posted By: A.D. Tejpal
Subject: Form_MultiColumn.mdb
Date 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: http://www.rogersaccesslibrary.com/forum/uploads/37/Form_MultiColumn.zip - uploads/37/Form_MultiColumn.zip



-------------
--

Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com



Print Page | Close Window